Totalling up different worksheets in excel

What you really need to do is have another sheet called Summary where you have your ulative figures, ie. external formulae which pick up the totals of each month which would then be added up automatically so you always have running totals.