Input Multiple Excel tabs at once

[sagarpatel11]

I am trying to use this one excel that has over 100 different tabs. I want to take specific information from each tabs and create an excel but I don't want to create 100 inputs. Is there a way to bring all tabs in one put and then tell it to take specific information from each tab and create an output. All the tabs are formatted similarly.

Thanks.

[ckorte · Accepted solution]

This prior thread about using the "Dynamic Input" tool should answer your question....

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Input-multiple-Excel-sheets-or-tabs-at-once/...

[NirajSingh]

Hi Sagar,
Please use input Tool and Dynamic Input Tool as well.

First Configure Input Tool with the file and import only list names in Input Tool then connect input tool with Dynamic Tool and configure it too.

Please find the below images for configuration. Hope it'll work.

Configure Input Tool as below Img1:

Img 2:

Configure Dynamic Input Tool Img3:

Image4:

Image5: