Consolidate Data from Different Tabs

[mohdabrar]

Hi,

I have data Month wise in different tabs in Excel. I want to create a Master sheet in the same workbook and get the data date wise from the other tabs in order.
For Eg: I have Tabs from July to December - 2022. I want the data entered in July Tab to automatically update in Master sheet Tab whenever a line is added. All the Tabs will have the same header. I tried the consolidate function, but it asks for calculation options, which I don't want to use. All I need is simple data consolidation. Any help is greatly appreciated.

Thanks,
Abrar.

 

[alansidman]

Use Power Query to combine the data.

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

 

[mohdabrar]

Thank you! that worked.