How to Link Sheets in Excel 2007
- 1). Highlight the content of the first (original) sheet you want to link in Excel 2007.
- 2). Click on the worksheet tab (at the bottom of your spreadsheet) of the worksheet you want to link to.
- 3). Select the "Home" tab. Choose "Paste" and "Paste Link" from the "Clipboard" group to link to the sheet.
Source...