Easy!
Click on the cell where you want the linked data.
Key in the equal sign: =
Navigate to the cell you wish link
Press enter

If you are linking to a cell in another workbook the cell will look
something like this
='[Workbook Name.xls]Tab Name'!$E$16

Where $E$16 is the cell location

Note that the cell location is an absolute reference so if you want to
extend the selection by dragging the cell you must first remove the absolute
reference.

If you are linking to a cell in the same workbook the cell will look
something like this

=Tab Name!Cell E16

Note that the cell location is not an absolute reference

HTH

Steve




"Sheilad" wrote in message
...
I want to link a number of cells from different spreadsheets into one main
stock control spreadsheet and I've no idea how. Any suggestions?

ie Stock control = 200

Order Number 50

therefore stock control should decrease to 150.

Many thanks in advance