Hi,
Here's the situation: I have 30-40 workbooks that are updated on a
weekly basis (the data for sure, the filenames might also change for
some of them), each includes a sheet with a pivot table (same fields
and layout in each, but pulling from their own unique ranges within
their respective workbooks).
I would like to somehow pull the data from each of these pivot tables
into one master file, and preferably then I can create one master pivot
table as well to organize the consolidated data.
I've tried my hands at using external sources and consolidated ranges,
but my expertise is limited in this area. Are there any VB macros, MS
queries, or anything else that would be the answer to my problem?
Thanks in advance for your help!
FYI: Using Excel 2002
Bookmarks