I have a workbook that is a yearly time sheet. Every week is a separate tab. The tab names are the dates of every Friday of the year. In cell B2 in the first worksheet contains the date of the first Friday in January, 2014. That same cell on the next sheet is linked to the first cell +7. The third sheet is linked to the first tab +14, etc....

I set it up so that I only have to change the date of the first Friday in January and the rest of the sheets update their dates accordingly so in 2015 all the dates change in a flash. However, each worksheet's tab is also the date in B2, but not linked. What I want to do is also have the sheet tabs names changed based on the value of B2 on each sheet so I don't have to rename them manually.

Is there an easy way to do this with VBA?