Copy linked cells without incrementing rows

[hungledink]

I have a sheet that has a tab for each month and a summary tab. The first 6 rows of each of the month tabs have data in up to columns AA.
In the summary tab, I want to have rows 1-6 linked to rows 1-6 in the January tab.
Then rows 8-13 linked to rows 1-6 in the February tab, and then so on down the sheet for the whole 12 months.

I’ve linked the rows for January into the summary tab and was going to copy those 6 rows, paste them into rows 8-13 and then do a find and replace substituting January for February. I intended to use this method to populate the summary.

When I paste rows 1-6 into 8-13 however excel incrementaly increases the rows. Is there a way to stop that? I know I could manually link each cell but I’m interested to know if the other way is possible.

Hope that makes sense.

 

[Max1616]

If you put "$" in front of the cell reference it will lock the reference:

Change A1 -> $A$1
Change A1:C100 -> $A$1:$C$100

Then drag down the formula and those reference will not change.

 

[hungledink]

I thought of that but there’s quite a lot of cells to manually change unless there’s a way to batch change them?

 

[Scott T]

Depending on your formula you may be able to fix the first one and copy accros

you can highlight the cell reference and use F4 to cycle though.

Highlight S1:S17
=sum(S1:S17)

press F4 and it becomes both absolute reverences, neither the column or row change.
=SUM($S$1:$S$17)

press F4 again and now only the rows are locked the column will change
=SUM(S$1:S$17)

F4 again and only the columns are locked the rows will change.
=SUM($S1:$S17)

F4 again and you are back to
=SUM(S1:S17)