Trying to make "xrefs"

I am trying to automatically reference the contents of another file into my main file.

Basically I have one schedule that I've automatically generated in AutoCAD, and another formatted template. The AutoCAD schedule is completely unformated.

I want to include a link to the AutoCAD scheule (a *.CSV file) on my main spreadsheet and have the autoCAD schedule populate my template.

I've done some reading, primarily on here, and I think I need to use either the INDIRECT() or the INDEX() function.

I can get INDIRECT() to work, but it's fairly repetitive (not overly important, but still.....). More importantly, though, the schedule file has to be open, which I would like to avoid if possible.

INDEX(), I just can't figure out how to work!

Any help or suggestions greatly appreciated.

dJE