Copy and paste to another master folder

[Excelexcel86]

Hi guys I’m looking for a macro to do the following. I have about 16 folders in total with different amount of data in all what I’m hoping to do is for every folder copy the most recent file they are csvs and put into master workbook but then when the original folders have new data put into them I want to copy the new file but then replace the file that was in the master from that folder .so basically it ends up with 16 files in master folder where each file is always the newest .

 

[sijpie]

Is each latest csv in a separate sheet in the master workbook?
Then it is quite easy:

1. Loop thru each of the folders
   1. Get the youngest file
   2. Remove the worksheet for that folder
   3. Replace it with the found file
2. Save the master

there are plenty posts on how to loop through folder
there are plenty posts on how to import a csv

On how to find the latest csv, here is an example: Open most recent .csv file in a folder

If you need help pasting this all together, let me know