Need formula to make a list of data from a running real time data entries.

[faistone]

Hello MrExcel, i want you to help me now.
How we get a coloumn that contain an updated list data entries directly from a running and real time recording?
example:
Day 1st
Time Name Buy

07.00 John 5 units
07.30 Smith 2 units
09.00 Alexa 3 units
10.15 John 2 units

Day 2nd
Time Name Buy

07.15 Smith 1 unit
07.20 John 10 units
09.00 Edward 6 units
10.15 John 7 units

ect....

Here I want to make a list moving data that record my customers directly and real time.
This is my goal.

07.15 Smith 1 units
07.20 John 10 units
09.00 Edward 6 units
10.15 John (data John)moves to 17 units automatically(data 07.20 - John auto removed) and continue to the day 2nd ect....

Best regards