Thanks for the reply, but I don't quite follow..

Basically I want an overview sheet (Stock Report) that will let me select products and tell me the number from Order sheet.. What steps to I take?

D2 in Stock Report then put in =sumif then select which part in the order sheet?