Merge multiple excel files sheets to one

[radha009]

I have three excel files with multiple sheet names

File 1: A, B  sheet names

File 2: D sheet name

File 3: E,F,G sheet names

Expecting result one excel file with all sheet names

One File : A,B,C ,D,E,F,G

Appreciate your help.

Thanks

[binu_acs]

@radha009 One way of doing this with the batch macro