Copy Paste Values For Entire Folder of Workbooks

We have a sales report that was created on a daily basis in excel with about 10 columns and 225 rows of data on a single sheet. There are two sheets in every workbook but I am only interested in the first sheet. There are formulas mixed through out the sheet. There is a folder for every month (ie, Jan, Feb, Mar, etc) and an excel report for each day of the month.

In order to create the database I would like to copy paste special all of the values before I start to work with them. What kind of code can I create that will allow me to copy, paste special value all of the cells in all of the workbooks without opening each and every workbook? I have about 3 years worth of reports which comes out to about 700 to 800 excel files.

After that I need to manipulate the data in each workbook into useable form, but I will save that for later.

I can almost guarantee that the people on this forum that can do what you need will want to see some examples of the the source workbooks before they will help you.