Macro to grab data from all sheets in given directory

Macro to grab data from all sheets in given directory

Closed - This job posting has been filled and work has been completed.

Job Description

I am in need of a macro that will grab information from all sheets in all workbook(s) located in a specific directory. I would like Columns A to N to be copied if column A contains a date. I would then like the rows copied on the second row of the workbook the macro is run from.

The workbook will be called ErrorDatabase, while the sheet with the consolidated info should be called ConsolidatedErrors.

I would to be able to choose the directory in a manner similar to this: http://www.vbaexpress.com/kb/getarticle.php?kb_id=829