Hyperlink Creation

Hi guys,

New to the forum.

Hoping you guys can help, i have searched the forum already but none of the solutions make sense to me.

I have attached a sample file along with an explanation of my problem:

So here goes, each cell needs to have a hyperlink to the same directory but the file name is dynamic. Is there any way to do this quicker instead of doing linking each cell?