Hi,

I haven't been able to find a way to do this in the Help resources I found
so far:

I'd like to have a "report" workbook importing data from a number of other
"data" workbooks. I can make the external references manually, but that would
take a lot of time, and would have to be repeated every time there is a new
"data" file.
Is it possible to just write the filenames in certain cells and then make
the external references a function of the filenames (and paths) in those
cells? That way, every time there was a new "data" file it would be necessary
to add the proper filename to the list of paths.
Thanks in advance for your suggestions,

Andre Canelas
Delft, NL