Multiple excel files combine if match file names in one work book with different sheets

[Lalaiah]

Hi, I have multiple files saved in each different multiple folders with the same file names So, I need workflow if given folders the file name match all files should be combined as one work with different sheets.

[Emil_Kos]

Hi @Lalaiah,

How do you decide which folder you need to take into consideration?

You got a path or this is concatenation of different folders?

[SeanAdams]

Hey @Lalaiah 

Assuming the file format is identical - this is relatively quick:

• Use a directory tool to get all the file names and paths
• feed these into a dynamic input tool 
• Take the output from the dynamic input tool into a formula to calculate the new filename for your consolidated files
• Output tool which takes the filename from the data-set - this will break up your consolidated files based on the field you created above.