Code for Opening/Saving Hyperlink Content within Excel to a Specific Destination

Hello All,
I am looking for some advice. I have had a couple of VBA college courses, but I do struggle from time to time with determining how to get VBA to do what I need it to do.

My Question:

I have a spreadsheet with mulitple hyperlinks, representing indivdual mechanical drawings stored on a network drive. As of now, I have to click each hyperlink, open in AutoCad, then save to a folder for future edit. What I want to do is write a set of code which will parse through all of the drawing hyperlinks in a giiven excel column (listed seperately in one column) and automatically copy/save the actual drawing file from the network location to a specified local folder. I have recorded a few macros, but I'm not really coming up with anything that tells me exactly what direction to take.
Can anyone offer any direction on this one? I will be glad to provide any further details if needed.

Thank you in advance for any insight.