Copy files in subdirectories to a central location

[JeffGrant]

Hi, does anybody a piece of code that can.

1. Loop through a series of subdirectories
2. Find a file in each of those subdirectories with a file name that only changes by having the date added to it during saving
3. Copy the found file to a central location
4. Loop to the next folder

I would like to put all the csv files in one spot to import into Access.

All the files have the name of Main_Report-dd-mmm-yyyy.csv where dd-mmm-yyyy is the date that the file was downloaded from a data server.

This could be done manually, but it would a very long time as I have 12 months of files saved in folders by date.

Thanks

Hoping somebody can help me out.