I'm building a golf league spreadsheet that will hopefully make my
calculations each week easy. I've got some formulas that reference cells in
another worksheet.
=SUM('Weekly Input'!N3:N4)
When I tried to copy (drag) this formula down the column I get
=SUM('Weekly Input'!N4:N5).
"N3:N4" referece merged cells from my input worksheet. My worksheet this
formula is in has 18 columns with 16 rows. Is there a better way to
reference the merged input cells and also copy the information for ease of
setup.

(This is my input sheet) Col N
Team Player Score Weekly Score
1 Player 1 N3:N4
Player 2
2 Player 3 N5:N6
Player 4


I need the information in N3:N4 to show up in worksheet "Weekly scores" A1;
N5:N6 to B1, etc. there are 16 teams on the "input" worksheet and 16 rows no
the "weekly scores" worksheet.

I've tried to "copy" and "paste special" with "paste link" but that doesn't
seem to work either for copying down. Is there a faster way of inputing a
formula or reference without doing each cell one at a time?
Brad