[RESOLVED] Creating blocks with relative formulas

[westconn1]

i am trying to create a summary sheet for payroll and want to use formulas to get data from other sheets

each sheet has column A (a5:a68) containing weekly dates, with empty row between months and quarterly totals
i want to transcribe 3 columns (J,L and M) for each quarter and annual total, to summary sheet, sheet names are employee names + date



i can use a formula, =VLOOKUP("Total1",INDIRECT(CONCATENATE("'",C1," ",A1,"'!a5:n70")),10,FALSE) (thnx tntinmn), in C3 to reference the values from other sheets, but i would like to make all references relative to employees, so for rows 3 - 8 columns d,e, and f will look at C1, g,h and i will look at G1 etc, i can merge the cells in row 1 if that would help, also the column index for the vlook up can be somehow be matched to each required columns (10, 11 and 13)

the reason for doing this is so i can copy and paste the blocks as required, without have to edit all the formulas each time

i am attaching a sample workbook, i have, now, modified the total for each quarter to Total1 etc, to make the vlookup easier
sample.zip

new sheets are created automatically each period, or when required, so i would like to make as few changes as possible to the main sheets, but now is the best time to do it, before new sheets next month