Replacing a piece of a hyperlink in multi-tab

Is that 1st hyperlink exactly the same on all links? if not, what changes? DestA? Can you also confirm the actual current hyperlink because the displayed one differs to the link when you hover over it. Ideally just inserted as text so we can clearly see what is to be replaced.

I need to know exactly what the hyperlink looks like and exactly what you want to replace and with what, as your 1st link isnt clear then its not easy to tell.

ie to write what you want I need to know something like.

Link1: http: // www . mysite/part1/part2/part3/mypage.html

I want to replace the part1 with "NewPart1" and part3 with the name of the worksheet its on.

eg
Link2: http: // www . mysite/newpart1/part2/Sheet1/mypage.html