Try this:

A1 = sheet name = Sheet2

To return the value of Sheet2 cell B10:

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

--
Biff
Microsoft Excel MVP


"Patrick" wrote in message
...
I have a need to refer to a sheet name from a main sheet , I need to refer
to the sheet name dynamically, ie, can i place the name of the sheet in a
cell and then in another cell on the main sheet refer to that cell as the
sheet name and then add the cell address??


Patrick