Setting up spreadsheet

[nkidd]

I currently have a spreadsheet that tracks employee errors. I have employee
names accross the top in row 1 and a list of types of errors going down in
collum A. I put how many errors they made of each type in each persons
collum. I have each week on its own worksheet tab. I then have one more
worksheet that gives me totals and averages taken from the previous weekly
worksheets. This works great. I have only done this for one month. I now
need to start with one for this month, which will have a new total/average
sheet (I track each month seperatly). What would the best/easiest way to set
this up be? Each worksheet is named for the week (Aug 8-Aug12, etc) so they
will change each week. Is there anyway i can set this up so i am not having
to redo all of the functions on the total's page each month?

[ilanr01]

I currently have a spreadsheet that tracks employee errors. I have employee
names accross the top in row 1 and a list of types of errors going down in
collum A. I put how many errors they made of each type in each persons
collum. I have each week on its own worksheet tab. I then have one more
worksheet that gives me totals and averages taken from the previous weekly
worksheets. This works great. I have only done this for one month. I now
need to start with one for this month, which will have a new total/average
sheet (I track each month seperatly). What would the best/easiest way to set
this up be? Each worksheet is named for the week (Aug 8-Aug12, etc) so they
will change each week. Is there anyway i can set this up so i am not having
to redo all of the functions on the total's page each month?

One way, rename the sheets names before starting the new month, thr formulas will change automaticly
Another way is to name the sheets as week 1, week 2 etc.
Ilan