Input Multiple Files and getting output with multiple files

Hi Team,

I have attached the use case here and my requirement is Input Multiple Files and getting output with multiple files. Kindly help me

Workflow

Accepted answers

Do the files share the same column names and data types?

Regards

You can leverage the attached macro to open multiple files at once. I'm assuming they are xlsx. Let me know if they are not.

I attached an example with some files as well.

No Different columns and data type

All are .xlsx files... Input each files having same company in different excels and i need to spit company wise keep the in tab