Consolidate sheets into one tab?

[ai1094]

Hi,

I have a workbook containing multiple sheets with same formatting in each tab. I am trying to take all the sheets and create a pivot table containing the data from each sheet. Is this possible to do?

I am trying to avoid using a master tab because the information changes daily and the same line item type can be edited as well.
Please let me know if you need more information.

Thanks!

 

[alansidman]

Here is a tutorial on Power Query which is the quickest and easiest way to accomplish this.

Consolidate Multiple Excel Sheets Using Power Query Append

Power Query Amend in Excel is an easy way to consolidate multiple Excel worksheets. Click here for the free tutorial and start learning!

www.myexcelonline.com