Append/combine multiple worksheets from workbooks into one workbook

[macjagger17]

Dear Patrons, Newbie here.

I want to append/combine the highlighted worksheets- 5 int & 7 lql (screenshot Item 1) from multiple workbooks - 20220601, 20220602, 20220603.........(screenshot Item 2) into two worksheets in a new empty workbook - Master File (screenshot Item 3) .

Any help is appreciated whether it is Macro VBA or any kind of tools.


Item 1

Item 2

Item 3

 

[alansidman]

Combine Data from Multiple Workbooks in Excel (using Power Query)

Power Query can be of great help when you want to combine data from multiple workbooks into one single worksheet. Here is a step-by-step guide on how to do this in Excel. You can combine data when it's stored in an Excel table, or even when it's not formatted as a table.

trumpexcel.com