Referencing File Path - Dynamic Cell Input for Worksheet

Hello,

I have the following formula:

Please Login or Register  to view this content.

In workbook1 that references workbook2 having multiple worksheets (sheet1,sheet2,sheet3,etc....)

What I would like to do is reference a cell in workbook1 that contains the correct sheet number (ie. if I type "sheet2" in cell A1,workbook1, it will reference workbook2,sheet2)

Something like this:

Please Login or Register  to view this content.

where A1 = sheet2

Is this possible? I have seen the INDIRECT() function being thrown around but used in context of referencing the filepath location, not the sheet name after the file location.

Thanks in advanced,
Chomie.

That did the trick!

=INDIRECT("'[worksheet2.xlsx]"&K3&"'!$I$53")/1000

Thanks,
Chomie.