I have a workbook with 30+ worksheets
named 23 Wed, 24 Thur, 25 Fri, etc etc
meaning April 23, 2014 Wednesday, April 24, 2014 Thursday, etc etc

The next project may start on May 19, 2014 Monday - so I have to rename each worksheet
beginning with 19 Mon, etc etc
Renaming each worksheet manually takes a long time and is prone to error

I would like to just rename the first worksheet to start date of May 19, 2014 and have the rest renamed automatically.

Is there anyway to do this ?