I understand the difficulty: since elements on the first sheet are not
contiguous, creating outyear totals is not simply a matter of pasting
the totals column into a "Year 2" (or whatever) position.

Not knowing the layout of your information makes this a little dicey,
but here's a possibility. You can label the appropriate columns with
"Year 1", "Year 2", etc- suppose these appear in Row 1. On your totals
sheet, write a SUMIF along the lines of =SUMIF(A1:G1,"Year 1",A2:G50)
This sums everything in the range A2:G50 if there is a column header
"Year 1" in the first row. You can hide the labels in row 1 if you
need to.

Does this get you a little closer?