Dynamic acces to files in a shared directory on Google Cloud

[Claude_Ver]

SItuation

A directory "DirName" is shared with profile "to everybody having the link". The link to access this directory is something like "https://drive.google.com/drive/folders/blabla..."

IN this directory DirName, hundred of files with each a unique name and all the same suffix.

Somewhere else, a google sheet with the list of all the file names.

What I want to achieve is : when you click on a filename, this filename, stored in DirName should open.

SO I think to a kind of new link beeing the concatenation between the "link of the directory" + "the name of the file"

How to do that ???

Claude