Using the INDIRECT Function to Create References

[EliseFreedman]

Hi There

I am working on a workbook which requires a large amount of worksheets to be added to it. There is then a summary sheet which refers to the same cell within each of the worksheets. To save time I was hoping to have a column with the workbook name, a column with the worksheet name and a column with the cell reference. In my example my workbook name is in I48(T&C(Customised)), the worksheet name is in J48 (Operation_EmbarkingFuel) and the Cell ref is in K48($I$5). The formula I am using is =INDIRECT("'["&I48&".xls]"&J48&"'!"&K48).

I was expecting to get the value in that cell but instead I am just getting #ref. What am I doing wrong

 

[EliseFreedman]

Solved

 

[SkipVought]

Elsie,

Please post your solution for the benefit of other members.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}