Macros to pull data from multiple files

I have to collect data from production wells we have at our power plant, mainly pressure, temperature, and flow. The Control Operators at our plant generate an excel workbook every day, all with the same format. Each file is named according to the date (e.g. "07-20-11.xlsx, 07-21-11.xlsx, 07-22-11.xlsx, etc). I want to be able to have a master file with all the dates on the A column, and to be able to collect pressure, temperature, and flow from the said dated files (the location of pressure, temperature, and flow is constant on every file).

Using the example files I uploaded, "wells copy for excel.xslx" would collect the data from "07-20-11 EXAMPLE.xlsx" for date 07-20-11, from "07-21-11 EXAMPLE.XLSX" for 07-21-11 and so on. None of the dated files will be open.

I'm new to this macros/vba, and I suck at programming, so if you can help me out I'll appreciate it. I have to do similar things for a lot of files and manually changing file names just takes forever.

Thanks!