[ikthius]

I done a search for linking worksheets to cells in excel, and it gave me this:

Examples

The following example opens a worksheet named Budget Report.xls that is stored on the Internet at the location named example.microsoft.com/report and displays the text "Click for report":

=HYPERLINK("http://example.microsoft.com/report/budget report.xls", "Click for report")

The following example creates a hyperlink to cell F10 on the worksheet named Annual in the workbook Budget Report.xls, which is stored on the Internet at the location named example.microsoft.com/report. The cell on the worksheet that contains the hyperlink displays the contents of cell D1 as the jump text:

=HYPERLINK("[http://example.microsoft.com/report/budget report.xls]Annual!F10", D1)

The following example creates a hyperlink to the range named DeptTotal on the worksheet named First Quarter in the workbook Budget Report.xls, which is stored on the Internet at the location named example.microsoft.com/report. The cell on the worksheet that contains the hyperlink displays the text "Click to see First Quarter Department Total":

=HYPERLINK("[http://example.microsoft.com/report/budget report.xls]First Quarter!DeptTotal", "Click to see First Quarter Department Total")

although you don't have to use an internet domain name, you could just navigate to the file you want, and it should find the file, and get the required data.


ik

EDIT: or this:
create a link between cells in the same worksheet or workbook

1. Click the cell that contains the data you want to link to, and then click Copy [img]../images/0019.gif[/img] on the Standard toolbar.
2. Click the cell you want to link from, and then click Paste [img]Download Failed (1)[/img].
3. Click Paste Options [img]Download Failed (1)[/img] and then click Link Cells.

[img]../images/bluedrop.gif[/img]Create a link between cells in different workbooks

1. Open both the workbook that will contain the link (called the destination workbook), and the workbook that contains the data you want to link to (called the source workbook).
2. In the destination workbook, click Save [img]../images/0003.gif[/img].
3. Select a cell or cells you want to link from.
4. If you are creating a new formula, type = (an equal sign). If you are entering the link elsewhere in the formula, type the operator or function that you want to precede the link.
5. On the Window menu, click the name of the source workbook, and then click the worksheet that contains the cells you want to link to.
6. Select the cells you want to link to.
7. Complete the formula. When you finish entering the formula, press ENTER.

Or:
if on the same workbook
=sheet2!B2 (uses value in cell B2 on worksheet 2)