Aggregate data from multiple sheets into one dynamic master sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2767588%22%20slang%3D%22en-US%22%3EAggregate%20data%20from%20multiple%20sheets%20into%20one%20dynamic%20master%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2767588%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20multiple%20sheets%20in%20the%20same%20workbook%20with%20similar%20data%20arranged%20in%20the%20same%20manner%20(same%20headers%2C%20same%20position%20on%20sheet).%20I%20want%20to%20use%20a%20Pivot%20Table%20to%20report%20out%20on%20all%20the%20data%20in%20the%20multiple%20tabs%2C%20so%20I%20want%20to%20aggregate%20all%20the%20tabs%20into%20one%20sheet.%20I%20tried%20using%20a%20Query%2C%20which%20worked%2C%20but%20the%20Query%20wouldn't%20reflect%20updated%20data%20when%20the%20data%20on%20the%20respective%20tabs%20were%20updated.%20I%20also%20tried%20a%20simple%20Macro%2C%20but%20that's%20also%20only%20creating%20a%20snapshot%20of%20the%20data--it's%20not%20dynamic.%20I%20thought%20about%20creating%20a%20summary%20sheet%20by%20just%20using%20a%20lot%20of%20copy%2Fpaste%20link%2C%20but%20that's%20pretty%20messy.%20Any%20good%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2767588%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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

@ashlieg 

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