save hyperlinked .pdf to new file with macro

[machineinmyhand]

hi everone.

i checked lots of threads and i didn't get any answer for my problem. here' s what i need.

i got a list about my isometrics (.pdf files) in excel with hyperlink formula. nearly 500 isometrics makes 1 test package. some isometrics in test packages are changed and linked with hyperlink and those are not sorted sometimes there is blank cells between two hyperlinked isometric (not all of them hyperlinked).

so i need to select changed isometrics (hyperlinked pdf files in column E) and save another file named with test pack number in cell A2.

heres the link

https://docs.google.com/spreadsheets/d/1uEo518Rcd_I4kGiEDIE-2kLzS8Vg8wNJ2qsIqS1Gt5A/edit?usp=sharing