I'm an excel novice and only know the very basic stuff.

Let's say I have a set of 10 cells, B1-B10. I want to fill it up by manually entering numbers into A1 continuously. Take for example a set of numbers that begins with 3 and 6. 3 would be in B1 after entering it, but when 6 is entered into A1 3 would drop to B2 with 6 replacing it in B1. This would continue until it is filled up, and upon the 11th number being entered 3 wouldn't drop to B11 instead just being replaced by 6 in B10, so that there is only 10 cells of numbers at a time. Is this possible? Appreciate the help.