To have persistent updating of data between two spreadsheets, insert Dynamic Data Exchange (DDE) links:
Select and copy the range of cells to be linked to.
Change to the spreadsheet that requires the link and select the
Open the Paste Special dialog, Edit > Paste Special and check the Link option (the checkbox at the bottom left of the dialog).
Click OK to insert the DDE link.
What is supposed to be behind the "the"?
