If A1 contains:
Sheet3
then the formula:

=INDIRECT(A1 & "!A1")

will product the same result as :
=Sheet3!A1

This means you can change the sheet reference by changing a cell rather than
changing the formula.
--
Gary''s Student - gsnu200845


"KLE" wrote:

Excel 2003
I need to reference the value of a cell in a different worksheet and I want
the name of the referenced worksheet to be determined by the text content of
another cell. How do I format the worksheet reference to use the contents of
the other cell as the worksheet name?

For example, on Worksheet1 cell A1 contains the name of the worksheet I want
to reference, which is Worksheet2. The cell I want to reference in
Worksheet2 is B2. If I entered the worksheet name directly I would use
'Worksheet2'!B2. But what do I use in place of 'Worksheet2'! that is a
reference to the contents of cell A1?