Need help bringing in 12 sheets from 1 Excel file with same schema / 2 sheets diff schema

[slaurel]

Hi community! 

I am struggling with this file right now and could really use some help. I have an Excel file that has 14 total tabs. I only need 12 of them (all the same schema), BUT 2 of the other tabs that I do not need in it are a different schema, so my dynamic input skips all 12 of my files and I can't get it to work. I cannot delete the other 2 tabs because the 12 tabs I need reply on those tabs via formulas. I tried filtering the sheet names right after my original input (<List of sheet names>), but that did not work either. 

In each of the 12 tabs, I only need the range A93-J130 (Row 93 being the column headers). 

Can someone please mock up a small workflow that takes this in and spits out the right stuff?

I need tabs J, F, M, A, M, J, JU, AU, SE, O, N, D. I do not need the "Total" or "Year" tabs to be brought into the workflow. 

[abe_ibanez]

@slaurel, could you please confirm the configuration of your dynamic input tool? I just tried a mockup and it did work for me. 

Thank you,

[Raj]

@slaurel you can change it according to your requirements
1 use input tool to get all the sheet names from your file
2 use the macro
this will work

[slaurel]

@abe_ibanez That brings in my data all the exact same though. Each sheet has different numbers. It is copying the Jan data for every month. 

[abe_ibanez]

Please share the configuration of the Modify SQL Query within the dynamic input tool.

I normally use the replace string and use the incoming field to replace the whole sheet name.