Forum Discussion
Summarizing Data across Multiple Workbooks
I have a Spreadsheet which contains data across multiple TABs but we have one Excel for every project so we may have 50-100 spreadsheets, one for each individual project. All the spreadsheets have i...
Thanks for your reply. I am not familiar with the INDIRECT Function but will look at it, though I am not sure how I can cycle through and access all my external project workbooks. To help clarify my request, see the image below.
Regards
You might find this reference useful for three-dimensional summing, which is now what it sounds like you want to do. https://bettersolutions.com/excel/formulas/three-dimensional.htm
(FWIW, I read your initial description of a desire to produce a summary quite differently. To me a "summary" of many sheets picks off the salient or concluding or final figures of each sheet and reports them. It might also include a summary sum or two, but that would not be the essence of it.)