hyperlink error, connected to tab name that changes

[mckeamic]

I have attached a link of a screenshot of the workbook I am working on. I will try to describe what I need, but it might be easier to see the picture with it.

https://postimg.cc/BLm3d5t4

*in the workbook I have a main "DATA" worksheet & an individual worksheet for each individual egg. So...

1) On the "DATA" worksheet, in column A is just counting list of 1-600. In column B has the same corresponding number to the counting list (to the left, in column A), as we receive an egg the user will input in an egg log # that will get assigned to it in column B.

2) On the individual sheet, a lot of the information is auto-populated from information entered in the "DATA" sheet. There is a macro code in its tab that will take the egg log # it was assigned (on the individual sheet) from cell C7 and change the tab name to the egg log #.

Question: with example:
Is there a way to insert a hyperlink on the "DATA" page from column A {egg #} (cell A5),
to make it go to the individual page (even though its tab name will change), tab name now b1-27-3, was 1

Thanks in advance and let me know if you have any questions.

 

[Col Delane]

In the cell on the DATA sheet where you want the hyperlink, enter the following formula (in this case for the first logged egg in row 5):

= HYPERLINK( "#'" & $B5 & "'!$A$1", $B5 )

As is, this will display the sheet name in the hyperlink, but could be extended by adding text to the first argument in the function (but do NOT delete any of the existing components as these are what creates the link to the target sheet)

HYPERLINK is a function that returns a hyperlink rather than a native hyperlink created via the Insert menu. I use it in a Sheet Table of Contents for a workbook, where I enter the sheet name in column B and automatically get a hyperlink to that sheet wherever I locate the formula.

 

[mckeamic]

Thank you for all of your help. I will try it in the next few days, been busy at work and let you know if it worked.