linking to data in other worksheets

[YairDC]

I know the formula to link data from another worksheet is:
='WorksheetName'!A1
or
=[Filename]WorksheetName!$A$1
depending on whether that worksheet is in another file or not. I want the formula to obtain the file name/worksheet name from an adjacent cell, is that possible?

[Mark@Work]

You can use the INDIRECT() function to retrieve the value of a cell based on a string representation of its address.
However the INDIRECT function will only work on OPEN workbooks...

The ADDRESS() function can be used to assist in constructing the string representation of the address.

Mark.