In your original formula, apply "anchors" to the cell references, comme
ca:
=3DSUMIF(September!$B$4:$B$500,C61,S=ADeptember!$D $4:$D$500)

This prevents Excel from shifting the columnar cell references as you
copy the formula to other cells.