You could try:

Select the first cell in the target sheet and Right Click> Define Name
Choose a unique name

Make the link and then add after the hyperlink address #the unique name

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials