Merge some sheet to another excel

[adamasmay]

I want to merge some sheet to another excel.

Example from file input ---> I want to copy file to new file and merge sheet (except Paid_AR, Paid_CC , Detail , Special)
*same format

Please guide me about it.

Example : File input

output : Merge file

 

[GraH]

Easiest way is with Power Query.
Connect from a new workbook to the source file. Data Tab - Get and Transform - Get Data -> From File -> From Workbook.
In the navigator select the workbook name (the folder). You will see each sheet as a file in the folder.
Click on transform data.
In the preview window you can now filter sheetnames.
There is a column data. Select it and from the context menu choose "remove other columns".
Then expand this data column (icon with 1 arrows pointing up and to the side).
Close and load to excel, choose table as destination.