Issue with workbook links: enable content prompts sign-in to workbooks I don't have access to

Whenever I copy a worksheet with formulas referencing other worksheets within that workbook into a new "Destination Workbook", the worksheet is linked to the "Source Workbook" that it came from obvio...