Combine Multiple excel file with multiple tabs into one single excel file.

[sourabmehta2006]

I want to combine multiple excel file which has got multiple tabs like Sheet 1, Sheet 2 and Sheet 3. I want to combine only "sheet 1" from each excel file into one single excel file. I have uploaded the input files for your reference. Please help. 

[Ar13f]

Dear @sourabmehta2006 

Usually I use macros to work on problems like the one you are facing and where do I get the macro tools and learn from this community.

please find the article where I learn this macro https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...

thanks to @JordanB for the article you shared....

[Qiu · Accepted solution]

@sourabmehta2006 
We can use a macro for that.