VBA: Copy sheet x number of times and rename with the date of each week

Hi. I have a file that we use each week for a staff meeting. It uses a template that is the same for each week with the sheet named for the date (i.e., 04/30/2024). I'd like to use a button to add the next four weeks and rename each sheet with that week's date. Each date is a Monday so each sheet's name could simply be 7 days from the previous sheet.

Can you help me with the VBA code for this function?

Thanks for your help!

Perhab

Please Login or Register  to view this content.