Look in help for the Indirect function

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message oups.com...
I have the following simple formula

=Sheet1!B15

which of course prints the contents of "Sheet1" cell B15.

However what I want is to get which worksheet to grab from, from a
cell. Ie

1
A Sheet1

And then the formula would be something like

A1!B15


Is this possible? I tried a few combinations and couldnt get it
working.

Thanks!!!