Variable Link to Workbooks

[Guest]

I want to link mulitple workbooks in to one, is there a way to make the link
a variable formula so I can have the workbook names across the top of my
spreadsheet and use those in the link. This way I can just change the
workbook name on the top of the column and the data would change.

I tried using the INDIRECT formula but I get a #REF... I use the Indirect
formula now but not in a link to another workbook...

HELP !!!!

 

[Dave Peterson]

Harlan Grove wrote a User Defined Function that can pull from a closed
workbook:

http://groups.google.co.uk/[email protected]

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm