use cell content as cell address in formula

Cell a10 has no references. It only has the text "b2".

Indirect is definately what you need. Just type your formula as normal.

ie ='Sheet1'!b2

Then select a cell that is your reference cell. Anycell that you are not using will do. Say cell D4

In D4 enter Sheet1!B2 - note without the = sign and without any single quotes '

Then replace the formula in the cell that currently has ='Sheet1'!b2 with =D4. The returned value will be the same - because it does the same thing.

Matt

Working with the =INDIRECT(D4). Thanks a great deal.