how to get a link to follow a relocated cell address

[Covert Codger]

The attached excel file gives a full explanation of what I am looking to do. Essentially to get a cell address based on the adjacent cell's content and deliver that cell address. Then to have a formula update automatically to provide a link to said cell address as it changes due to insertion of new rows. See the attached and hopefully, it will be enough to understand what I am looking to do.

[Covert Codger]

Well, I guess this how to get a link to follow a relocated cell address post will continue to fall into obscurity. I thought surely by now it would receive something. My bad.
I just checked and it is in the middle of page 3. Looked maybe 30 minutes ago and it was at the bottom of page 2.
Going, going, gone.