Extracting HyperLink Text Location

I am trying to extract a “Text” location which is hyperlinked so that It can be attached to the copy of same file on to another Google Drive.

Please suggest a way. Its a challenge for me a Rookie.

Thank you,