Creating "Living" List/Database

I am attempting to create a "living" list of values that automatically updates based on the value that is entered in a single cell.

EX: At somepoint in time cell A1 is manually filled with an arbitrary value. Later, cell A1 is overwritten by another arbitrary value and the original value is lost. I would like to have a program that writes the original value to a list on a separate sheet and each time cell A1 is changed, the subsequent value is added to that list.

Any ideas??

i think VBA would be needed for that so you can write the value in A! and press submit and it will add it to another spread sheet

PHP Code: 

Public Sub yourmacroname()


Application.ScreenUpdating = False

Dim copySheet As Worksheet
Dim pasteSheet As Worksheet
Dim xrow As Integer, xcol As Integer


Set copySheet1 = Worksheets("your page name where A1 is located")
Set pasteSheet = Worksheets("page name ofwhere you want the value to go")

copySheet1.Cells(1, 1).Copy
pasteSheet.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues


Range("a1").Select

End Sub 


ive edited mine so sorry if it doesnt work correctly

Thanks so much! Works perfectly!