Inserting Worksheet Tabs in Excel 2003

I have a user who needs to insert additional worksheets in a new workbook each month. But, they want to rename Sheet 1 to the first day of the month (i.e. 3-1-07), and then easily update the rest of the worksheets to be the rest of the days of the month (i.e. Sheet 2 becomes 3-2-07). Is there a relatively easy method to accomplish this?