Combine multiple Excel with Same Sheet name

[AJ_AJ]

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 solution]

@AJ_AJ 
This is where we use Dynamic Input tool.

[binu_acs · Accepted solution]

@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