Create a milestone workbook with Gantt Chart and RAG status and publish in powerpoint

Hi All,

Need your help for creating a Milestone workbook. There are a list of things that I intend to cover in this workbook:

1. The milestone workbook will be linked to a Gantt Chart . The user will update the Milestone name(per project) , and date along with the RAG status in one tab. This gets reflected in another sheet as Gantt Chart along with the RAG getting reflected as a triangle with the (RAG colour).
2. In the event the PM changes the date of the milestone.. he is prompted to update the reason in the comments field in the first tab
3. Is there a macro that can publish the gantt chart in a ppt slide if the user selects the option?

I havent created any drafts as yet, appreciate if you could share any template that could meet the requirements.

Happy to share the ppt version of the gantt view that we intend to publish.

Thanks in advance

Response anyone