New to programming: Macro to open hyperlinked word doc, copy/paste into adjacent cell

Hey everyone

I was wondering if someone could guide me to the proper resources or help me to come up with a macro for the following:

Cell 1 Cell 2 Cell 3

Hyperlinked text to word doc Text of word doc

Basically I have columns of hyperlinks to word documents and in the adjacent column, I'd like to have the copied and pasted content of those documents.

This would immensely help me because right now I am clicking the link, Ctrl+A, Ctrl+C, closing the document, then Ctrl+V-ing each and every time.

I tried to record a macro (in excel) but it seems that the code doesn't recognize the select all/copy functions done in the word document. I've also created a shortcut macro (in Word) just to simplify the select all/copy functions under one shortcut but it doesn't save me enough time.

Thank you!!