Hyperlink to list of PDF files in directory and match with Excel entry in Column 1

Hi everyone and I hope you can help me. I have an Excel s/s with entries in column 1 that correspond to the PDF's in a folder - that's the easy part!

The next part I need help with and that is that there are multiple entries in column 1 which correspond to each PDF and they can be 1,2,3,4 or any number of instances that correspond to each PDF.

I would like each column 1 entry to hyperlink to the correctly (same) numbered PDF in the folder.

Now I found the following VB code which creates the hyperlink to each PDF in a folder but I want it to also hyperlink when there are multiple entries of each instance in column 1.

Ideally I would like it to just produce the filename, hyperlinked without the path or any other info.

Thank you in advance and here is the code for hyperlinking to a folder.

Clarification

I thought I would try to clarify what I need.

I need the DocID entries to hyperlink to the corresponding PDF files in the folder and open when clicked on.

Thanks.

DocID Invoice Number Case Number
CDFA_54875 1112522 5478
CDFA_54875 1112523 5479
CDFS_55423 1112524 5480
CDFS_55423 1112525 5481
CDFS_55423 1112526 5482
CDFS_55423 1112527 5483
CDFW_56743 1112528 5484
CDFW_56743 1112529 5485
CDFW_56743 1112530 5486
CDFW_56743 1112531 5487
CDFW_56743 1112532 5488