Change Sheet Tabs and match sheet cells with tabs

[timgavin]

Hi I really hope someone can help me.

What I have is a workbook with 31 tabs dated with the current months date. Each sheet cell also has the date at the top. The sheet themselfs have a site name, start time finish time for the various site I am responsabily for around the country.

Every month I need to rename each tab and sheet to the new date for the next month ensuring the new months date are matched to the sheets weekends.

What I need is to be able to change the tabs and the cell on the sheet with the date to the new corrosponding months date ensuring the weekends mathc the weekend sheets by clicking a button. I have the below code witch ads sheets after specifying the start date and end date, but what I really need is to be able to rename the existing tabs and sheets.

PLEASE HELP!!

 

[villy]

Kindly site an example sheet.

 

[timgavin]

hi Villy I will post tomorrow as I do not have a copy on my laptop. thankyou for your response.

 

[timgavin]

Hi villy

Please find attached sample of one sheet. I have another 30 or 31 depending on the month. We use these as a checksheet to monitor sign on of staff at various remote sites.