Refer to a sheet using a cell value

[bony_tony]

Hi, on "Sheet1" in cell A1 I have the string "Tony". I also have a
sheet named "Tony"
I want to display the value of cell A1 in the sheet "Tony" on
"Sheet1".
Instead of using =Tony!A1 I would like to somehow use the the value in
A1 ("Tony") to refer to the cell. I can then copy the formula to other
cells easily to reference other sheets..
Thanks

 

[Mike H]

Try this

=INDIRECT("'"&A1&"'!A1")

Mike

 

[bony_tony]

Thanks for filling another hole in my Excel knowledge! ;-)