I am trying to figure out how to reference worksheet names that change based on cell values.

For example, we have 52 worksheets - One for each week of the year. We have a date field in the first worksheet and all other sheets calculate the date based on the preceding sheet (cell+7).

We then have a vba script that changes the name of the worksheet to the date of the week.

The problem is if we change the date in the first sheet, the script to change the name of the worksheets does not work until you click in the date field of each sheet.

So the question is how can one have all of the worksheet names updated once the first worksheets date is changed. Hope that makes sense.