Input Excel sheet of different format at once

[Abhishek10]

Hi Team,

In my file, there are 50 sheets with different format which I want to import to start processing, can someone suggest a better way to import all different sheets at once?

[SPetrie]

A batch macro is your best bet here.

There are multiple solutions with examples you can use but this one may be a better fit for you. Check out the link and see if that helps.