ms excel

hello sir,
iam working as an accountant in cardiac scan centre.I want to know about the links in ms excel i.e links between two different spreadsheets e.g. Spreadsheet and spreadsheet 2. I want to make changes automatically when i have done changes in spreadsheet 1, it might change automatically the spreadsheet 2. what can i do?