Single Spreadsheet From Many Spreadsheets

I want to create a single spreadsheet containing a selected row from each of 365 spreadsheets;

Background:
(1) I have 365 Excel spreadsheets (1 for every day of the year);
(2) Each spreadsheet contains:
(a) 24 values (one for every hour) horizontally with hourly average temperatures; and
(b) 8,000 records (vertically) for 8,000 different locations;

I want to create a new single spreadsheet in which I select a specific location (say, Linden, New Jersey), and capture the temperatures for all 24 hours (horizontally) and all 365 days (vertically);

the file names are all;

20070101.xls, 20070102.xls, 20070103.xls, ............ 20071231.xls (one for each day of the year)

(I tried using =VLOOKUP(Linden,CONCATENATE(A1,A2,A3,"'.xls'!","$B$1:$CA$8017"),3,FALSE); where A1, A2 & A3 are year, month & day respectively) but was unsuccessful;