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