Use cell containing absolute address for a cell in another workbook in a formula

[sawsheen]

I have a worksheet with multiple workbooks.
A cell in sheet1 e.g. A1 contains $W$5.

I would like to use the contents of A1 in a formula in sheet1 to return the value from sheet2, sheet3, etc

I've entered this into a cell in Sheet1 but it doesn't work.

='Sheet2'!CELL("contents",A1)

Appreciate any help. Thanks sawsheen.

[Pete_UK]

Do it like this:

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

A1 should contain a valid cell reference.

Hope this helps.

Pete

[sawsheen]

Pete - worked great! thanks