Import multiple excel file and multipled sheets

[prpanw]

Hi Folks,

I have a folder where 4 excel files are saved and each excel file has 4-5 tabs. I want to import all the excel files with all the sheets and combined into one file 

note:-  Every sheets has common 21 columns. I want  to combined them only.

[binu_acs]

@prpanw batch macro is the option for your use-case, sample workflow attached, change the directory path inside the workflow