I have a simular problem that I can not resolve. I want to reference a cell
in another workbook. So if cell A1 contains the name of a worksheet in
another workbook. So I would like it reference ,,say cell B2 in "sheet2" of
another workbook.

e.g.

If Workbook 1/Sheet 1/Cell A1 contained "Sheet 2" and
Workbook 2/Sheet 2/Cell B2 contained "Find Me"

How can I from Workbook 2/Sheet 1 Cell C2 "find" the text "Find Me"?

I have tried =INDRECT("[Workbook 1.xls]'A1'!B2") and several other
variations without success.