Help Needed want to impress the Boss

[Suggy]

Hi all
After a back injury my boss as taken me of fitting and put me in charge of the stores.


I am slowly sorting the stores out which was like a bomb site but to make my life easier I want to put the entire stock on a pc.
I am having a little problem with incoming stock when entering the figures into the spreadsheet


What I am trying to do is on delivery’s (Sheet1) is enter the amount in Colum D and the when I put a "y" in Colum E and press Enter or Down Arrow the amount being added to Stock (Sheet2) Colum G and the Delivery amount (Sheet1) Colum D being deleted without it being deleted from the Stock Sheet2) Colum G

Attached is what I have done so far

Hope this makes sense and someone could solve this for me and help me gain some brownie points.
Thanks in advanced for any help offered