VBA code that will follow excel hyperlink to word doc & copy text back into excel

Hi All, I am sort of reposting a different version of a question that I posed earlier - please note that I have now attached a copy of a small fragment of the worksheet that I am using, along with a sample of the word document.

To restate:

I am looking for a way to have excel search a WORD document in a certain area of the sheet and generate what is found at these coordinates. If this is not possible, I can also make with having excel search for a certain phrase and then generate the text that comes directly after the specified.
- Either of these options will do

Currently I have set up a =hyperlink formula that creates a link to the word document specified in the column A.
Ex. "M1000" - Brings user to a microsoft word document that outlines "protocol m1000"
"M1005" - Brings user to a microsoft word document that outlines "protocol m1005"
"M1007" - Brings user to a microsoft word document that outlines "protocol m1007"
etc. - etc...

So as you can see, I have the documents basically attached to the excel document already.

In 2 other columns I want excel to search the corresponding documents and generate the "effective date" of the protocol and the " short description"


I hope that I have explained my situation in great enough detail.
Please give me your guidance. Thank you for the help !