I have a large number of individual spreadsheets (about 1,000) which contain reports which are generated multiple times per day. The reports have the same fields, but the individual values are not always on the same line of each spreadsheet - but they are always in the same order and have labels.

I need to extract 15 pieces of data from Excel spreadsheet and to generate a single spreadsheet for analysis which is set up in 15 columns with approximately 1,000 rows.

So, what the deliverables for this job are:
1. A single Excel sheet with 15 columns and approx 1,000 rows of data.
2. A macros which can be used to perform a similar task on future Excel sheets.

I have attached a few examples of the spreadsheets and a spreadsheet showing the setup for #1 above. If you have any questions, please do not hesitate to ask before bidding. This job may well lead to others as I have related projects coming.