Question: how to link data in two excel spreadsheets?
Answer: On the Data tab of the ribbon, in the Connections group, click the Edit Links button. ... 
In the Edit Links dialog box, click the link you want to work with.