conoslidate from different files with same format
 

Dear all

i am working with Excel XP edition and in a local network having one public
folder.
In this folder i am saving 14 files which all of them has the same format.

I am trying to consolidate some of their sheets.
I though to use the vlook up function including the indirect formula but
indirect will not work if the 14 files are open. if any of the files are
close i have a REF.

Does anyone have any good ideas how can i work in one workbook by pooling
data from the 14 files without to have all of them open?
The challenge here is that the next month i will create a new folder with
another 14 files, so i have to change all the links.
Any good ideas? Do i have to use a VB code to solve the problem?

Thanks in advance,