Create Hyperlink from one Tab to another based on Cell - Hyperlink needs to move when cell moves

[LaputianSky]

I have a spreadsheet with multiple tabs.
I am using one tab 'Integration Details' as an at a glance for source information.
I am using multiple other tabs, all split by date, to show sessions on those dates will more information including invitees.

I want to be able to click on a 'Session Name' within the 'Integration Details' Tab and be taken to that session in the relevant dated tab (I have managed to get this working via a Hyperlink)
However, when I Cut and Paste that session to another tab (Date/Time of the Session has changed) the Hyperlink still reverts to the original place.

All suggestions on how to fix this welcome!
Additional note, I am not great at using VBA, and already have a script running for a completely different issue, so if VBA is the only answer, please can someone explain how I have multiple VBAs running in one workbook?

 

[myall_blues]

This is the method I use. It doesn't quite fix the problem but it makes maintenance a lot easier.
First set up a 'Link references' tab - it can be hidden later if you don't want it visible. It has two columns - a link column containing a reference to where you're session details are (tab and cell) and some 'friendly' link text.

Book1
	A	B
1	Link	Link Text
2	#'2024-07-09'!A1	2024-07-09 Session 1
3	#'2024-07-09'!A30	2024-07-09 Session 2
4	#'2024-07-16'!A1	2024-07-16 Session 1
5	#'2024-07-16'!A30	2024-07-16 Session 2
Link references

Then on the 'Integration details' tab add a series of =HYPERLINK formulas that point to cells on the link references page. Then if you move some session data on a date tab to somewhere else, all you have to do is update the reference on the 'Link references' tab.

Book1
	A
1	Sessions
2	2024-07-09 Session 1
3	2024-07-09 Session 2
4	2024-07-16 Session 1
5	2024-07-16 Session 2
Integration details

Cell Formulas
Range	Formula
A2:A5	A2	=HYPERLINK('Link references'!A2,'Link references'!B2)

 

[LaputianSky]

Thanks Murray,

I don't think this would offer me much benefit on this occasion, as the Integration Tab has the link / friendly text as well as the date/time of the meeting, so if a meeting moves, it would be updated there first and as I move the session Id update the link as part of that one process.

I was just hoping there would be a way to avoid the need to manually change the Hyperlink :D

 

[myall_blues]

Are you able to post some test data for us to see how it is currently and to work with (especially if it needs a VBA solution).
Preferably using XL2BB - Excel Range to BBCode

 

[LaputianSky]

Unfortunately my Companies Security features do not allow for me to download XL2BB

Here is a screenshot of the Integration Tab;

Here is a screenshot of the Dated Tab;

I have hyperlinked C9 On the Int Tab to A4 on the Dated Tab

But if that entire section, A4-A30 ends up moving to another tab, I have to manually change the Hyperlink

Hope this makes sense