So nevermind...After a few hours of searching on the forum I found an answer that helped me

In case anyone will have the same problem or a problem like this.
I'm using this code that searches for the target name with .pdf extention and it makes the hyperlink:
HTML Code: 
You just have to play with the code a little to make it work in your workbook for the stuff you want.