Autofill VLOOKUP function

[gutter_mutt]

I've got a workbook that tracks the weekly performance of my team members in each category they are scored on. Every week I add a new worksheet with their performance data. The first worksheet, entitled aggregate needs to compile the data from each consecutive worksheet (week 09, week 10, week 11, etc...)

The function needs to be VLOOKUP because team members can change from week to week, so a progressive cell value formula would be no good. The first cell in the aggregate worksheet uses the following formula:

=VLOOKUP(A2,'Week 09'!A1:I24,2,FALSE)

each consecutive cell from left to right needs to go like this

=VLOOKUP(A2,'Week 09'!A1:I24,2,FALSE)
=VLOOKUP(A2,'Week 10'!A1:I24,2,FALSE)
=VLOOKUP(A2,'Week 11'!A1:I24,2,FALSE)

and going from top to bottom

=VLOOKUP(A2,'Week 09'!A1:I24,2,FALSE)
=VLOOKUP(A3,'Week 09'!A1:I24,2,FALSE)
=VLOOKUP(A4,'Week 09'!A1:I24,2,FALSE)

so the formulas in each cell in a 3x3 grid would appear as follows

=VLOOKUP(A2,'Week 09'!A1:I24,2,FALSE) =VLOOKUP(A2,'Week 10'!A1:I24,2,FALSE) =VLOOKUP(A2,'Week 11'!A1:I24,2,FALSE)
=VLOOKUP(A3,'Week 09'!A1:I24,2,FALSE) =VLOOKUP(A3,'Week 10'!A1:I24,2,FALSE) =VLOOKUP(A3,'Week 11'!A1:I24,2,FALSE)
=VLOOKUP(A4,'Week 09'!A1:I24,2,FALSE) =VLOOKUP(A4,'Week 10'!A1:I24,2,FALSE) =VLOOKUP(A4,'Week 11'!A1:I24,2,FALSE)

however, Excel autofill makes them go like this

=VLOOKUP(A2,'Week 09'!A1:I24,2,FALSE)  =VLOOKUP(B2,'Week 09'!B1:J24,2,FALSE)  =VLOOKUP(C2,'Week 09'!C1:K24,2,FALSE)
=VLOOKUP(A3,'Week 09'!A2:I25,2,FALSE)  =VLOOKUP(B3,'Week 09'!B2:J25,2,FALSE)  =VLOOKUP(C3,'Week 09'!C2:K25,2,FALSE)
=VLOOKUP(A4,'Week 09'!A3:I26,2,FALSE)  =VLOOKUP(B4,'Week 09'!B3:J26,2,FALSE)  =VLOOKUP(C4,'Week 09'!C3:K26,2,FALSE)

There are 6 sections on the aggregate worksheet that need the same thing, with an average of 20 team members and 52 weeks, that means if I have to fill each cell individually with its formula, I'd have to fill 6240 cells. How can I get excel to autofill each cell with the formula that I want?

I've attached a copy of my workbook (I've changed my team members names to user1, user2, etc...) in case it helps.