total to date

[excelchallenged]

I prepare a monthly report of Firefighter's hours per day, fire calls per
day, medical calls per day, etc. AT the end of each month, I total each
indiviidual's numbers of hours worked, number of calls run, etc. How can I
then calculate totals-to-date from January's worksheet into February's
worksheet and so on throughout the year?

[rocket0612]

unless I am missing somthing, should it not be just a case of in Febs sheet, having a formula like: =Sheet1!Cellref+Sheet2!Cellref, eg in the cell you want the running total in feb to be as A1 for example, input a formula like =Jan!A1(cell that total is in jan = A1 or whatever)+Feb!A1?