Forum Discussion
Need help in merging excel worksheets from different workbooks
Hi all I want to merge worksheets from different workbooks, but I cant merge more than two sheets into a master file if the name of the sheets are same. How do I go about this? Example: I've ...
Replicated 3 workbooks similar to yours, each containing a sheet named ACT
The attached sample has a query that Combine/Append (not merge) Sheets named ACT
All query steps done with the User Interface only
I don't want to merge all the data from multiple workbooks into a single sheet, instead I want to move worksheets of same name form different workbooks into one workbook.
OK. Not sure I can help further as it's not doable automatically with Power Query (one query = one output)
If you run Excel 2021 or 365 look at Export Data From Power Query into Multiple Excel Sheets based on criteria. You would use the query I shared then use the above VBA solution to split your sheets combined as a single table
