Aggregate data from multiple sheets into one dynamic master sheet

Occasional Visitor

I have multiple sheets in the same workbook with similar data arranged in the same manner (same headers, same position on sheet). I want to use a Pivot Table to report out on all the data in the multiple tabs, so I want to aggregate all the tabs into one sheet. I tried using a Query, which worked, but the Query wouldn't reflect updated data when the data on the respective tabs were updated. I also tried a simple Macro, but that's also only creating a snapshot of the data--it's not dynamic. I thought about creating a summary sheet by just using a lot of copy/paste link, but that's pretty messy. Any good ideas?

1 Reply


If you mean Power Query it shall update all data on Refresh All.