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??