Copyiing formulated rows from one sheet to another

My knowledge of Excel 2007 is minimal, from formatting individual cells, to creating column totals. I've used it for years in my household budgets. I have a project that is challenging me to ask for help. I have an attendance form which is about 3 pages long; currently, it's separated at page breaks, with column totals at the bottom of each 'page'. This is easy because the Row #s are infinite, right? Lately there have been regular adjustments, and I believe the project might be less cumbersome if it were spread out on separate sheets, but I have no idea how to bring the rows of column totals to cumulative totals on the last sheet.

If I explained myself adequately, and if someone could offer some help in "layman's terms", I would really appreciate it.

I found it!

=SUM(Sheet1!B45+Sheet2!B45+Sheet3!B45)

I simply copy this formula for each column in the row.

I edited my 1st reply to ask for a little more help. I'll be happy to mark it as solved soon.
TY