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

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/ta-p/1243