Automatically hyperlink worksheets when values entered

Hi all,

I would appreciate some assistance from the gurus here. I have an excel file that is used to record information about particular projects. We need to record dates related to these events and these are stored on separate worksheets. These use a key of sorts, where the unique references are replicated on all worksheets.

I have set up the data sheet to generate the unique identifier and the hyperlinks to the Received! and Sent! worksheets automatically as new unique references are added to the Data! worksheet.

What I would like is a VBA code to populate hyperlinks in the Received! and Sent! worksheets in column B, to link back to the Data! worksheet unique reference.

I had used formulas in the past, but the Data! worksheet is massive. I've needed to write hundreds of hyperlink formulas referencing blank spaces in the Data! sheet in anticipation of new projects. It would be better if they were populated as the sheet expanded.

Much appreciated. Dummy sheet attached.

Thanks daffodil11,

I didn't really explain that well. I'm ok with the links being populated in the Data! worksheet. What I'm looking for is links to be generated automatically in the Received! and Sent! worksheets (back to the Data! worksheet).

I have previously used: =HYPERLINK("[Dummyfile.xlsm]Data!$A2",Data!$A2) with conditional formatting to hide the error values. However, because of the volume of entries being added to the file, there are hundreds of errors being hidden.

Is there a way of adding this hyperlink automatically when a new unique reference is entered in the Data! worksheet

=Data!A2

Conditional formatting so that 0 leaves the cell blank.