Combine selected column in all tab of a excel file

[mandeepgujral]

Hi,

I want your help as I want to combine the only selected information from the same 50 tab (different information of same trend) of excel file into one output excel file.

Note: Excel screenshot and excel file is attached for your reference. 

Thanks

Mandeep

[Sachinsg1]

Hi @mandeepgujral,

Here you go. Maybe my approach is different, but it should work fine. I have kept extra column with account number. If not required you can remove in the select tool. If it works fine mark reply as accepted.

Thank you.

[DavidP · Accepted solution]

Have a look if the attached workflow does what you need.

Point the Input data tool to your file and make sure the option List of Sheet Names is selected.