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!