Question: how to copy a hyperlink from one excel sheet to another?
Answer: Select cell B1. ... 
Press Ctrl+C to copy the cell contents (the hyperlink) to the Clipboard.
Select the first worksheet in the series (click the tab for that worksheet). ... 
Hold down the Shift key as you click on the tab for the last worksheet in the series. ... 
Select cell D50.