Current Sheet Tab name change to text in cell a1

I have workbook with 26 sheet tabs in it, 4 sheet per month, I want some how if i change the name in one of the cell it change the sheet name as well, or if I change very first sheet to Jan 1 then next sheet add 7 more days it, I mean to say next Tab name should be Jan 14, then jan 21 jan 28 & feb 4th

or I can enter all these date on first sheet and it change from there,

This will prompt you for a start date. Then it names the 26 sheets beginning with the start date and adding 7 days to each date name. Will that work for you?

Please Login or Register  to view this content.

It works, thanks a lot