Weekly Monthly data compile macro help

[mundae]

Hey
I do not have that much experience with macros but have been trying a few things out for past few days. Any help would be appreciated.
So a .csv file gets generated everyday and is saved in "C:/Logs/" folder. This csv file has a format MMDDYY06.csv. I need to generate weekly and monthly report using these files.
So an ideal situation would be:
On opening a macro enabled excel file or on triggering a macro, Data from previous seven days gets complied and the new file is saved in folder "C:/Weekly report/".
Same for monthly macro file.
If the folder doesnot contain say 7 files then it will compile from last 3 days. So basically filter is based on filename and not the range on columns.

[mundae]

Some help with the coding would be appreciated..