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 : safe1
I have 3 excel files placed in safe1 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. safe1 folder) from where I need to collect data.

Now there are multiple folders i.e. safe1, safe2, safe3
each folder has multiple csv files.
Need the data of each folder to be appended in separate sheets of a single workbook.
example
sheet1 of workbook would have all the data in the csv files located in safe1 folder
sheet2 of workbook would have all the data in the csv files located in safe2 folder etc



Please help