Using LOOKUP over multiple sheets

[tmd63]

I have a multi-sheet workbook which has some sheets called Week1 Week2 etc.
I also have a sheet with a range of dates in column AB4 to AB35

In the worksheet Week1 etc, I have dates stored in row B5 to H5.
I have a named range called "SheetList" which contains the names of the worksheets Week1 to Week53.
I need to search B5 to H5 row to find a match with the value in AB4 to AB35 and if a match is found, I want to copy B7 to AC4, B8 to AD4 etc, all the way to B11 into AG4

I attempted to use a modified version of the following code:

=VLOOKUP(A4,INDIRECT("'"&INDEX(SheetList,MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$A$1:$c$4"),A4)>0),0))&"'!$A$1:$c$4"),2,FALSE)

But it just returned #N/A instead of the correct values.

I heard that LOOKUP is better than VLOOKUP or HLOOKUP. How do I use LOOKUP to find each cell value as described above?

 

[tmd63]

Just to be clear, I am working this using Excel 2003.
I want this to be workable using functions in cells and NOT VBA.