Hi,

I am putting together a selection of workbooks and sheets relevant for various department. There is to be one work book that calls al the releveant data from the other workbooks whether they are closed or not.
One of the files is a csv file.
The aim is the single file to have the date typed in. This would be for example 2012-02-18
When the date is typed all the references for the other sheets reflect to that as each of the other workbooks filenames is the date.
This works as straight formulas when typed in except the csv file. I have added a button that when the date is entered it opens the csv file, copies the data, pastes it into a work sheet called data source, and then closes it. Not ideal but working.
I want to not have to do that for the other work books. I want to just have the filename change in all the formulas. I have used the INDIRECT Function but the other work books need to be open. I cannot install INDIRECT.ext. My next option is looking up the grove pull technique but was wondering if anyone had any other ideas?

Thanks,

Alan