Oops; missed out the quotes

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

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Use INDIRECT()

A1 = Sheet1
B1 = "Test"
In C1
=INDIRECT("'"&A1&"'!B1)
will refer Sheet1!B1

If this post helps click Yes
---------------
Jacob Skaria


"Steamer" wrote:

I want to specify a worksheet name in one cell then use that name as part of
the reference address in a number of other cells.

Or, to put it another way, I want a number of cells to refer to various
cells in another worksheet, where I specify the name of that worksheet by
typing it into a single cell.

Is this possible in Excel?