I have copied a workbook that I used in 2006 for a simalar use in 2007. The
workbook has 52 worksheets which names reflect the Sunday at the end of the
week; (Week Ending 1-8-07, Week Ending 1-15-07, Week Ending 1-22-07...)

I would like to add a function that ties all the Tabs to the first Tab. When
I change the name of the first Tab to "Week Ending 1-7-07" I would like the
remaining 51 Tabs to change accordingly.

Can someone give me a suggestion?

Darrell