Picking the correct sheet based on client name

[Karthick_sankar]

Dear All,

Each client send their excel input files with different sheet names, how to combine all the client input files into one? (lets assume the columns are in the standard format) Please advise if you have any solution to combine if the format is not standard and the starting row is different.

Thanks in advance.

Karthick

[patrick_mcauliffe]

Have you tried the Wildcard XLSX macro from Crew?

http://downloads.chaosreignswithin.com/Macros.zip

[randreag · Accepted solution]

hi @Karthick_sankar 

You can also build a macro to read the differents sheets and the advantage is you can customize the things that you need.

I attached an example 

[Karthick_sankar]

Thanks for sharing 🙂