Copy specific cells from multiple spreadsheets onto new spreadsheet

[nivekb24]

I am using Excel 2007. I have a need to extract certain info from spreadsheetsthat I have saved in a folderand populate a new spreadsheet. This will allow me to quickly search/filter the address so that I can see what Job# was that the site was evaluated on. All of the spreadsheets use this same form as shown in the example below. The cells that I need to extract are the Job# (E8), which changes on every new sheet, and the address info for each site/row. There may be as many as 40 sites on a sheet but as few as 1. Below this example is another example of the spreadsheet and the results I am looking for. Basically I need to have the Job#'s indexed to each of the corresponding sites that were evaluated on that job. I'm sorry about the format of the examples, i don't think I copied them into here correctly but the cell #s are correct... I hope someone can help. My file quantities are growing too quickly for me to be able to search all of the time!

Estimate Page

	B	C	D	E	F	G	H
2
3
4
5
6
7
8			Job #	2014-081203
9
10
11
12
13
14
15
16		MANDATORY REQUESTOR INFORMATION
17	Site Information
18	Site #	Bulding/Site Name	Street Address	City	State	Zip Code	Site Contact Name
19	1	Site 1	100 Pine Street	New York	New York
20	2	Site 2	200 Elm Street	Buffalo	New York
21	3	Site 3	300 Maple Street	Boston	Massachusetts
22	4	Site 4	400 Locust St	Newburgh	New York
23	5
24	6
25	7

<tbody>
</tbody>

Sheet1

	A	B	C	D	E
1	Job#	Building/Site Name	Street Address	City	State
2
3	2014-081203	Site 1	100 Pine Street	New York	New York
4	2014-081203	Site 2	200 Elm Street	New York	New York
5	2014-081203	Site 3	300 Maple Street	New York	New York
6	2014-081203	Site 4	400 Locust St	New York	New York
7	2014-090101	Site 1	27 First St	Albany	New York
8	2014-090101	Site 2	45 Second St	Albany	New York
9	2014-091506	Site 1	56 Hoover St	Tucson	Arizona
10	2014-091506	Site 2	67 Jones Rd	Tucson	Arizona
11	2014-091506	Site 3	23 Phoenix Dr	Tucson	Arizona
12	2014-091506	Site 4	88 South St	Tucson	Arizona

<tbody>
</tbody>