Consolidating multiple .csv files into one worksheet

[sarad agarwal]

Hi All,

I have a use case where I want to consolidate multiple .csv files from a single folder on any location to the file from where I was running the macro.

I want a click button on a file which will allow me to select the folder and auto consolidate all the .csv file in the open workbook.

Files copy specifications.
1) file must always be .csv format
2) header from only one file should be copied as the header for all the files will be same

Any help will be highly appreciated.

Thank you in advance.