Not sure that we have enough info, but here is a starter

='Stock Control'!A1-'Order Number'!A1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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