VBA to Auto Populate the “AutoPopulate” sheet as data is being entered in EnterData sheet

Looking for VBA code to auto populates the “Auto Populate” worksheet as data is being entered in the “Enter Data” worksheet (main data entering sheet). VBA conditions:

VBA Code Conditions:
1. When I go back to make changes to the data entered in any ** the cell, the Auto Populate worksheet should capture the changes. For example, if I delete Product name Soya in row 3, column A and re-enter Milk, milk should be captured for the Product name
2. If one mistakenly enter data in row 6, column A instead ** the next empty (row 4 column A), the VBA code should auto populate the data on the next empty cell in the Auto Populate worksheet (see sample data)
3. If I delete all the data entered in the Enter Data worksheet, the Auto populate sheet should retain all auto populated data. When new data is entered, the auto populate should continue on the next empty row

Note: The Auto populate worksheet is a database to hold data entered into the Entered Data worksheet.

Thanks in advance.