Multiple Excel Workbook - Combining Multiple sheets (Different Schema)

[suby]

Hi All,

I have two Input files for one for the Month end of Jan and Feb with three sheets in each workbook but for My output I'm interested in only sheets S1 and S3.

I've attached the expected output could you please help with a macro to combine all the data when there is different schema.

Many Thanks

[binu_acs]

@suby One way of doing this with the batch macros

[suby]

HI Binuacs,

Thanks for the macros but is there way to get the desired output as attached in my previous posts.

[binu_acs · Accepted solution]

@suby Attaching the updated workflow