combine multiple excel with different number of sheets in one excel with multiple sheets

[ankur13agrawal]

I have a scenario where i have 3 excel with number of sheets as x,y,z and at output i need one single excel with number of sheets as x+y+z

[BRRLL99]

use 3 different inputs tools
for each input tool select only sheet names
combine all 3 inputs using union tool

[Qiu]

@ankur13agrawal 
I believe this is the one you are looking for.

https://community.alteryx.com/t5/Community-Gallery/Import-Multiple-Excel-Workbooks-amp-Multiple-Shee...

[binuacs]

@ankur13agrawal Another option to use either a batch macro or dynamic input tool

[ankur13agrawal]

Hi,Thanks for the response

actually i have many excel  in a single folder and number of excel will keep on changing,therefore i cant make the number of input as fixed

[ankur13agrawal]

Hi,Thanks for the response

its not possible for me to mention exact sheet names  as in my actual scenario i have 10+ excel with each having 5+ sheets with different names

[binuacs]

@ankur13agrawal try the below workflow