To print hyperlinks column and save filename for another column

[otisotis]

Hi everyone,

I got a column D that contains the list of hyperlinks that is set to print as PDF (as per attached ss)
however its a hassle for me to repeat click hyperlink and then print as PDF then save the filename as per column A

Is there a macro available for me to run the macro that print/save the hyperlinks in column D, and save the filename as in column A, saving all these hyperlinks file in certain folder location?

Appreciate the great help!