please help me on this

Firstly , Cell B1 will take the value from A1
then if A1 value changed ,the new value will be in Cell B2.(B1 will not change)
if A1 changed again ,it's value will be in Cell B3.(B1,B2 will not change)
if A1 changed Again ,it's value will be in Cell B4.(B1,B2,B3 will not change)
and so on

please can you do it by formula, if not by VB macro.


thank you in advance
Reda.