You have to do something like this:
Go into your spreadsheet and select the cell that you want to link to the cell from the work sheet. On this cell press '=' so that Excel will know that you want to enter a formula. Now go to the work sheet and click the cell that you want to link to. A doted line around this cell will automatically appear. Then hit Enter.