Easiest Way to Link Cells in Microsoft Excel
This seems so much harder that it really is. To link a cell to another worksheet, just copy the cell you want to link to. Go back to the cell where you want the data from that cell, and hit Edit Paste Special Paste Link.
Now, to link to another workbook, you do the same thing. The only rule is that you must have the workbook you copy from be open until you paste the link. But you copy and paste it using the exact same method.