I have numerous Sheets which are named using dates from 01.12.09 right through to 30.11.10. The 1st sheet has a cell in B1 containing the date and that sheet is named after the inputted date. This applies to all the other sheets which are calculated from what is input in the 1st sheet and each individual sheet is renamed manually to coincide with the inputted date. Each sheet is identical in format.

Is it possible to have the Sheet names automatically named when the 1st date on the 1st sheet is input? I ask as I have to update the sheet each year and renaming each tab is a chore!!