Need to make a macro which can append all the excel files ( names may vary) that are located in a particular folder. The number of rows in the excel sheets can vary. For example:

folder name is : storage
I have 3 excel files placed in storage folder, i.e. home.csv, HereIam.csv and There.csv


I need the data from all three to be in a single excel sheet.

So the data of the first excel will remain at the top of the sheet, the data of the second excel will be pasted below the data of the first excel and then the data of the third excel will be pasted below the data of the second excel, until there is no more excels in the specified folder ( i.e. storage folder) from where I need to collect data.

Please help