Combine multiple Excel with Same Sheet name

Question

Hi Team,

I'm Looking to combine 50 Excel files and these files have Multiple tabs, They all have One sheet name in common lets say "XYZ" in all Excel files, I am looking for combining the "XYZ" tab from all files to do a Consolidated analysis. Please let me know if there is any way I can develop a Workflow by using the standard Alteryx Tools.

Thanks in advance.

Qiu · Accepted Answer

@AJ_AJ 
This is where we use Dynamic Input tool.

binu_acs · Accepted Answer

@AJ_AJ another option with batch macro

change the directory tool path and update the filter tool with the sheet name you want to include