Please help me with micro do this

IN THE EXAMPLE SHEET I NEED DO THIS
I NEED VBA MICRO GIVE ME THE RESULT SHOW IN SHEETS
I HAVE STORE AND I HAVE ACTUAL QTY IN STOR LIKE SHOW IN (STORE_List) SHEET
- WHEN I RECEIVE GOODS FROM WAREHOUSE TO STORE I NEED TO BUT ITEM IN (Submit_STORE_Ins) SHEET I NEED MICRO TO SUM QTY AND ADD IT TO (STORE_LIST) IF THERE IS NEW ITEM ADD IT IN NEW ROW IN (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (Submit_STORE_Ins) SHEET
- WHEN I RETURN GOODS FROM STORE TO WAREHOUSE FROM (Submit_STORE_Outs) I NEED MICRO TO SUB ITEM QTY THAT I'M GOING TO RETURN IT FROM (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (Submit_STORE_OUTS) SHEET.
- AT THE END OF SELLING DAY I'M GOING TO COLLECT SELLING ITEM AND PUT IT ON (STORE_SALES) SHEET I NEED MICRO TO SUB ITEM QTY THAT I'M GOING TO SALE IT FROM (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (STORE_SALES) SHEET.
- AND I'M GOING TO COLLECT RETURN ITEMS AND PUT IT ON (STORE_RETURN) SHEET I NEED MICRO TO SUM ITEM QTY THAT I'M GOING TO RETURN IT FROM (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (STORE_RETURN) SHEET.