Alternative for INDIRECT

Hi All

I have used the function INDIRECT in 1 of my files.
The disadvantage is that both files (source and target) have to be open.

Is there a substitute for INDIRECT that works with a closed source file?

Thanks
Hein