Sheetname in fromula

[Abdul]

Hello,

I have several worksheets in my workbook(1)

and in workbook (2) all the sheet named of workbook(1) in Cells A1 thru
X1


can i use the text in cell A1 thru X1 in a formula to reference the
workbook(1)

for example in cell A2 instead of ='[Workbook 1.xls]Sheet1l'!$A$2 can
i reference Cell A1 in workbook (2) instead of sheet1, since in
workbook (2) cell A1 text is sheet1

Thanks

 

[Max]

='[Workbook 1.xls]Sheet1l'!$A$2

Believe INDIRECT is what you're looking for ...

With Workbook 1.xls open,

Try something like this in the sheet in your "workbook (2)",
say in Sheet1's A2:
=INDIRECT("'[Workbook 1.xls]"&A$1&"'!A2")
where A1 contains: Sheet1

Copy A2 across to X2 to return correspondingly for the other sheetnames
labelled in B1:X1. Ensure that the sheetnames labelled in A1:X1 match
exactly (except for case) with the actual sheetnames within Workbook
1.xls. Look out for any inconsistencies eg: typos, extra spaces, etc
which could throw the matching off.