How to macro hyperlinks placed at the right cell?

I have a macro (Photo_Hyperlinks2) that creates a hyperlink for every file found from a specific folder in Column A of Sheet 1.

The rest of Sheet 1 is my long version of doing what I want the macro to do... place the hyperlinks at the right spot. Sheet "Checksheet" makes a hyperlink of the already made hyperlinks (from Sheet 1) ONLY if the hyperlink in Sheet 1 is found. Same goes for the hyperlinks (1), (2), (3), and (4).

I really want to get rid of having to create a Sheet 1. I'm pretty sure there's a way to tell a macro to place the hyperlinks that contain "id" and/or "est" on the right row number in sheet Checksheet, and that if that row (in Checksheet Sheet) contains a (1) -(4), put it in the right cell, while also ommiting the first part of the name (ex: from 123445E(1) to (1)) ; I can live without that part if it can't be done.

Sheet "Checklist Using C-G Columns" shows the hidden columns not seen in Sheet "Checklist". Those manually inputed numbers are there mainly to tell that if more than 1 of the cells on the row are filled out, then to create a new row below it, and to continue the hyperlinking with (5), (6)... etc.

The final product is supposed to look like Sheet "Ideal Checksheet", except that ideally links (5)... etc. should work, and columns C-G are hidden again.

Any help is greatly appreciated.

Oops... small minor mistake on my uploaded file, but excel forum won't let me remove my uploaded sheet.

I'll just send it again. THIS IS THE file.

Any help is greatly appreciated :-)

Any ideas guys?

Any... ideas?

What if I were to change the file name structure of the hyperlinks... would that help?