I am creating a meetign agenda workbook that contains 52 worksheets, 1 for each week. I used a VBA Macro from another thread that allows me to name the worksheets based on a value in a cell. My difficulty is that the sheet name only updates when I enter something into a cell or the worksheet changes somehow. I would like all the worksheet names to update when the value in the date cell, which is A1, changes.

Any help would be appreciated.

Sincerely,
AJD