VBA code for a word document to up load items (Graphs and charts) from excel

Estimated duration: not set
Description: I have developed two files for a utility company i work with. I need to embed a word document into and excel document that will open using a buttoned macro, once open the word file needs to get information from the excel document open.

I require the word document to to automatically update the (month, and year) corresponding with the excel sheet, also transfer tables and graphs from the excel sheet to the word document.

The word document is going to be a monthly report, so once the information is transferred a manager (with no IT knowledge) will complete the report adding H&S information etc. The word document will be "saved as" making the VBA dead. so once the document is saved as a different name, the links to the original excel document needs to be broken and never updated.

There is a maximum of 15 items (graphs and charts) between Excel to word to be transferred upon the opening of the embedded word document