References to cells in other files

[Daniel]

I have a number of excel files, each containing a project.
The files are named with consecutive numbers + project classification, ie.
326fi1257, 327mb112, 328fi121710 where the consecutive numbers are 326, 327
and 328.
I also have a status file containing data from the excel files.
I would like to let the status file look up certain data in the project
files. The data to be looked up are placed in the same sheets and cells for
each file.
If possible I would like to use only the consecutive number as criteria for
the references.
Does anybody know weather it is possible?
And how do I do it?
If it is not possible, I could change new filenames to only include the
consecutive number. Would that help?

 

[Tom Ogilvy]

with code. I assume the files will be closed when you reference them. If
so, there is no worksheet function to support this. Indirect does not work
when referencing closed workbooks.