Running totals across spreadsheets

[Rachel]

I used the PX() function as suggested by Don in another
posting, but when I continued to insert more sheets then
went back to recalc the formula in the cell, they started
reverting to zero. The function and formula combination
he gave only worked on the first sheet in inserted using
that formula. I read your reply to that PX() function and
you completely lost me. Below is what I have. I can
email you direct, a copy of the workbook if you like.
Send me an email if you want a copy of the workbook:
(e-mail address removed)

I have a workbook that has 3 sheets in it:
Resume
Resume (2)
Resume (3)

On each of these sheets there are the following three
summary cells at the bottom:
Today's Total: $5.00
Previous Total: $0.00
Running Total: $5.00

On Resume (3) I have a button, with the below macro
assigned to allow the user to click it and insert
subsequent Resume sheets as needed. Each sheet represents
one day the man was out on the job.

Sub CopySheet()

ActiveSheet.Copy Before:=Worksheets("AsRun")
Range("G7").Select
Range("G7,C21,A23:G71").Select
Range("G7").Select

End Sub

I need code to add to the above macro that will write a
formula referring to the Running Total on the previous
sheet into the Previous Total cell on the new sheet,
because my users know nothing about formulas, keeping in
mind that this last sheet (Resume (3)) will be copied over
and over, so the formula cannot be absolute or at least
the sheet reference in the formula cannot be absolute.

Can you help??