Question: how to copy hyperlink from one sheet to another in excel?
Answer: Select the information to be copied and press Ctrl+C. ... 
Switch to Excel and select the cell where you want the link to appear.
Click the down-arrow under the Paste option on the Home tab of the ribbon and then click Paste Special. ... 
Choose Hyperlink from the list of options. ... 
Click OK.