I am trying to use INDIRECT.EXT function to get values from a different
worksheet.

I am typing the path in a cell in the following format in cell A1:

"'G:\Operations\Timesheets\2005\[2005_abcd.xls]YTD'!$N$6"

and then using

INDIRECT.EXT(A1) function

but I am getting #REF instead of any values.

Can anybody help resolve this or suggest a better option. I have to type
the path there is no way around it. Please help.