Follow, download, and rename hyperlinked files?

Hi all,

I have a spreadsheet with 5 columns, the last column being a hyperlink to a PDF stored on the internet. I'd like to automatically download each PDF, and to rename the downloaded PDF to include the text in the first column. An example is attached.

Could someone please help me figure out how to do this?

Thanks,

Rob