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
use 3 different inputs toolsfor each input tool select only sheet namescombine all 3 inputs using union tool
@ankur13agrawal I believe this is the one you are looking for.
https://community.alteryx.com/t5/Community-Gallery/Import-Multiple-Excel-Workbooks-amp-Multiple-Sheets/ta-p/996552
@ankur13agrawal Another option to use either a batch macro or dynamic input tool
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
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
@ankur13agrawal try the below workflow
