Hi All,
i was wondering if it is at all possible to automatically hyperlink documents in an excel spreadsheet?

What i'm trying to create is a register off all received documents from emails which are save on a server in a dated folder (2018-05-25) i was wondering if excel could look that folder (documents received) and then hyperlink all the documents into cells?

i have created a workbook template for you see what i'm trying to achieve.

Document Register -1.xlsx

Thank
ND