Excel: read multiple sheets separately

[tomekgagola]

I have long excel dump of data with number of tabs (in excess of 100). All sheets are named starting from Sheet1 to Sheet1**.

Data in sheets is all over the place so before I can UNION all sheets I need to bring into the same format and column order. 

I use Dynamic Input to read sheet names but struggling to find the way to import sheet by sheet separately. 

I can do it manually and read sheet by sheet but wondered about automated solution.

[christine_assaad]

Hello @tomekgagola 

Is the problem that you can't union the different sheets since they have different format? If yes, have you tried to use a batch macro and configure it to read in the different sheets and stack data based on Columns' Name? TY!