Summary Sheet of Multiple Files

I wonder if you know can help solve an excel problem I have.

I have hundreds spreadsheets all in the same directory on a server, all with similar names (test1.xls, test2.xls etc.)

Each spreadsheet is identical in format, only the data changes and I want to summarize certain cells on a separate spreadsheet. For simplicity I would want to see the value from test1 cell A1, B1, C1, D1 and E1.

Currently I copy the line above and paste it below and then do a search and replace for the next filename I want to add. Is there a way that I can type the name of the spreadsheet in the the summary sheet and then the formula would incorporate the name from that cell and automatically retrieve the data from the other sheets?

Does that make sense? Can it be done without VBA (i'm not a VBA user yet)