Multiple project arms with different anchor dates. Best way to solve?

Hello! We use excel to do project planning. Within a single project, we have multiple arms that follow the same event intervals but oriented to different anchor dates. Example attached

Currently, we create a new schedule for every Project Arm in order to project the proper event dates, but I'm sure there is a more efficient way wherein the Project Schedule would be created once, the Anchor Date for each Project Arm would be entered, and the system would automatically produce the event schedule for that particular Project Arm by referencing the Project Schedule

So, what's the best way to approach this problem? I've done VBA in the past but not really in connection to excel, and I'm not really sure that's even the best way to go about solving this. Any advice to get me in the right direction would be much much much appreciated.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks for the help, Pepe! I've attached a mock-up workbook to the original question and edited for clarity.