I'm trying to design an intelligent way to pull cash flow data from ~80 files into a single summary file.
The 80 files will have 12 sheets each (1 for each month of the year) from which data needs to be pulled but kept separate.
Each of the files will be formatted the same way (revenues in one column, expenses in another, descriptions in a third)
I see the final file as a pivot table with each file as a heading and the months as sub headings.
What is an elegant way of doing this?
I can think of a few ways to brute force the problem by writing all the cell references for each section of each sheet but there has to be a better way.
Ideally I should be able to add/remove from the 80 files.
Thank you for any help!
Bookmarks