Hyperlink files from folder or sub-folder for the whole workbook

Hi,

I've posted a request to this forum requesting a few weeks ago - to link an attachment based on the name specified in a column, then lookup the file name in a specified folder & sub-folders and change the file name to hyperlink, keeping the name the same.

Someone responded with the attached codes. It works perfectly. :) However, when I try to apply the codes to the actual file, I came across a few issues:

a) If I designated column E to store the hyperlinks for all the worksheets, what codes to use in order to make it work for the whole the workbook. Otherwise, I might have to create different macro for differnt worksheet

b) Also, if I inserted the file names on E18 and E19, when I run the macro - I received hyperlink on E15 to E17. Do you know how I can remove that? If no data on column E, then do nothing. I found a code on the website to clear off hyperlink generated in error (E15 to E17), but if possible, I would like to have that embedded into one macro.

Thanks in advance.

I'm suspecting that changing the codes to lookup the workbook will take awhile to run, in that case, how do I change the work for multiple worksheets?

Thank you,