Automatically updated formulas?

[Vic_from_sweden]

Hi,

I have "inherited" a spread sheet from a co-worker and I don't like at all.

Every month we get a sales-report that are added to the sheet. After that my co worker would add text to the formulas.

See the document below

When the July numbers come I'm supposed to Copy them into a docuemt like that as a new tab. Is there a way so that the formulas in the "Total"-tab are updated automatically when a new tab is added? So I don't have to add text to each cell in "Total".

Every month is made from the same template.

Thanks in advance

/ Vic