Now im avake i realised there is another way :-)

Paste this formula in Sheet-STOCK B2 and copy down
=SUMPRODUCT((SUPPLIED!B2:B20=STOCK!A2)*(SUPPLIED!C 2:C20))-SUMPRODUCT((SOLD!B2:B20=STOCK!A2)*(SOLD!C2:C20))