I am working on a spreadsheet that has a master sheet named weekly chart and a lot of other sheets named by dates. On the weekly chart sheet I have dates that I change each time I send the spreadsheet out. When I change these dates I want it to change all the sheet names on the remaining sheets. I am new to VBA codes and can't figure out what code to use and how to make it update when I change the dates. An example spreadsheet would be awesome if someone could e-mail one to me!!! Thank you!