Macro that combines data from several workbooks in a folder.

The FCC has started to list numbers that have had a complaint filed on them

HTML Code: 

. I will be reviewing to determine if specific numbers are appearing in these reports. I will go and download the CSV files weekly and want to be able to run a macro that will open and combine the data of all the workbooks for that week into one master file. I do not know where to even begin with open workbooks in a folder. Step further would be to autofilter based on a specific phone number if listed, but I think I can manage that. I attached one workbook, but you can go to the FCC link and download the more if you'd like.


Can anyone assist? Thanks!

Thanks Marvin and AlphaFrog!