right now i am using a formula:

that looks up the values in an external spreadsheet called "week1.xls". I have 19 of these, all named week1.xls, week2,xls, etc all the way up to week19.xls. I want to know how to make excel go through all these sheets retrieving the data. Thanx.