create a simple inventory tracking in excel

Thank you fro your reply. I checked it. This almost what I need. But it would be confusing for my father. Reservation tab does not make any sense in my case. But this is almost what I need.

I basically have 2 columns :
sheet1: Product Name  Quantity sold. In sheet 1 my father every day removes quantity sold as tmr is a new day and new sales data will be entered. 
What I want is to have a second sheet(sheet2) and exactly the same columns that will duplicate quantity sold but will not remove entries in the sheet2 when my father removes values in sheet1. I want to have running/accumulating total quantity sold or how people call it, snowball effect. it would be nice if I could see sales daily, weekly monthly and not just total quantity sold for each product