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

--
__________________________________
HTH

Bob

"Eric" wrote in message
...
Does anyone have any suggestions on how to set the formula?
In cell A1, there is a given number 5.
In cell B1, ='5'!A12.
I would like to change the formula by retrieving the 5 from cell A1
instead
of type into the cell.
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric