Web Links Not Copying

I have a workbook with multiple tabs, each has a different set of information. I am trying to bring over specific lines to a new tab as a summary. I use = in a cell in the new tab, then select the ra...