Same format & func. for 07 worksheet

Need you Help please.

I'm a real rookie here!!!!

I have a worksheet set up by a former co-worker last year. It has formulas
set up for our sales contracts. The spreadsheets has formulas
for total sales, commission on the sale, labor cost, margin etc.

My problem is I would like to use this same format and formulas for 2007.
How do I go about starting fresh on this worksheet without losing the formulas and format. If I delete all the rows out, just leaving the headings,
I have a new worksheet for 2007, but all the formulas are now also gone.

I would really appreciate your input.

Thanks,

Walley

Instead of deleting all the rows, why not save it with a new name, over-write the data for the rows that you have new data for, then delete the remaining rows?