I am trying to find a VBA or formula that will let me do the following:

I have information to add in Cell A5 of sheet 1. Every time I insert info in this cell I want this information to be transferred in Sheet 2 Cell A5. It is not a copy and paste as I want this information to be permanently inserted in Sheet 2 Cell A5. If I delete the information in Sheet 1 Cell A5 then I still want to have Sheet 2 Cell A5. Then, when I insert another text in Sheet 1 Cell A5, I need it to copy the information on the next line in Sheet 2 Cell A6.

Sheet 1 A5=123 therefore Sheet 2 A5=123 if I delete Sheet 1 A5=123, Sheet 2 is still A5=123

If I add more info to Sheet1 A5=456 then Sheet 2 add a line after A5=123 therefore A6=456

Let me know if this is complicated.

I also need this information to be transfered to a Sheet 3 but that I will figure it out.