Reading an Excel file with several tabs

[Jaloy_1973]

Hi Community,

I'm dealing with a dataset that is an Excel file with several tabs with the trial balances of several companies exported from SAP. 

I wanted to transform them (this is OK), but I did it creating an input per tab and copy paste the workflow made. 

My question is if there is a way to simplify the workflow, from a single input, make the workflow to read every tab (tab number may change), run the process, and make an output per tab in a single Excel.

Some guidance? Any suggestions?

Many thanks, 

Jordi

[TimN]

Check here:

https://community.alteryx.com/t5/Community-Gallery/Dynamic-Multi-File-Sheet-Names/ta-p/919218