The syntax for referencing another page is: =Sheet2!A1
If the sheet name contains a space, it will need to be contained within '
', so 'Sheet With Space in Name'!A1.
This can be inserted into a formula in the following way:
=SUM('Sheet With Space in Name'!A1:A200)
So on your totals page you could have in A1: TOTAL HOURS: And in B1 the
formula =sum(Hours!C2:C42)
(If column C on the hours page contained hours data).