Combining Specific Excel Tabs Across Multiple Excel Files

[Frye2]

Hi!  I would love some help trying to do the following:

I have 5 years worth of monthly data. Each year contains 12 different excel files for each month. Within each month excel file there are 20 tabs for different department P&Ls. Each tab is in the same format

My end goal is to create one file with 20 tabs for each department where each tab has every monthly P&L within it over the last 5 years. Is there a easy way to do this? Each Department should show 60 different periods within the one tab for 2015 - 2020. 

THANK YOU for the help! 

[Qiu]

@Frye2 
The input tool allows you to input only Worksheet names, then together with Dynamic Input Tool, it could get what you want.

[atcodedog05]

Hi @Frye2 

Give a look into this link

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

And

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-multiple-excel-files/td-p/549984

See whether it helps you out.