Formula in Excel

[Hodsocks]

I am sure this is simply enough to do but I'm just not up to speed with excel, I am producing a simple series of spreadsheets for someone to use as a register of people attending class. So far I have 12 sheets, one per month, and on each I have the list of names and the dates they have attended. At the end of the spreadsheet I have a total for the month and also a year to date total.
What I want to know is how to I transfer the year to date total to the next spreadsheet so that by the end of the year they have the toatal for the year.
Many thanks in advance.

 

[CCT]

A1 (January), A2 (Feb), etc - A13 (total) = A1+A2+ etc

 

[TangoTrolly]

To reference data on a different Sheet, use the 'Sheet' function. For instance if you want to add contents of A1 on Sheet1 to contents of A1 on Sheet2, use this formula: =Sheet1!A1 + Sheet2!A1

Following URL has the full explanation:
http://www.homeandlearn.co.uk/ME/mes12p2.html

 

[Hodsocks]

Thanks you guys, job now sorted.

 

[TangoTrolly]

Thanks for posting the outcome.