Autofill VLOOKUP function

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

and going from top to bottom

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

however, Excel autofill makes them go like this

Please Login or Register  to view this content.

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.

That's what I did, although the formula in the cell is changing correctly, it's copying cell values. Using my attached workbook, if I put =VLOOKUP(A2,'Week 09'!A$1:I$24,2,FALSE) in cell B2 and then drag it to cell B23, the formula in each cell will appear correct, but the cell value 0:00:00 appears in each cell. If I drag from B3, then 0:00:19 appears in each cell

try
=VLOOKUP($A2,INDIRECT("'week"&TEXT(COLUMN(I1),"00")&"'!a1:i24"),2,FALSE)

type it in, its either pasting as text/the cell is formulated as text/or calculation is set to manual.