Combine multiple sheets under single workbook

[poornimak]

I have 10 different folders and Clients 1, 2, 3...

Folder A

Folder B , C, D....

In each folder I have files with different client names and same sheetnames

Folder A -> Client-1.xlsx -> Sheetname-abc

Folder A -> Client-2.xlsx -> Sheetname-abc

Folder B -> Client-1.xlsx -> Sheetname-def

Folder B -> Client-2.xlsx -> Sheetname-def

My expected output is I need a consolidated file for each client with all the relevant sheets from different folders:

Final Output Folder -> Client-1.xlsx -> Sheetname-abc, Sheetname-def

                                -> Client-2.xlsx -> Sheetname-abc, Sheetname-def

Note: I don't want my file format to change as the data in the Sheetname-abc and Sheetname-def are dynamic and are formatted with reporting tools as per the business requirement 

Please let me know if there is any solution for this

[binuacs]

@poornimak have you tried the batch macro

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[binuacs]

@poornimak