linking mutiple files

[Bob B.]

Hello,

I have 76 files that I need to be consolidated (sumed)
into one master file each month. I name the files such
that the name is the same except for the month (ex.
Report_South_06_04 & Report_South_07_04). Is there anyway
to make the link to the other files dynamic so that I just
change the date in the master file and it updates the
links to the 76 files to the new month. Any help or ideas
would be greatly appreciated. Thank you.

Bob B.

 

[BrianB]

1. Best method is to have all data in 1 file and analyse using pivo
tables or formulas.
2. Could have a folder for each month and use files of the same name
except for the summary - so links don't need changing.
3. Edit/Replace the month in the formulas of the summary file