I have a work sheet that I use to monitor dates. I need to track up to 5
dates at a time. I would like my worksheet to update automaticaly when I
change the dates.

Let me explain.

The data in A4 through A12 never changes.
The data in B4 through B12 changes weekly.

I need to track the last 5 changes made to B4 through B12.
ex. Lets say B4=10/20/09. I then change B4 to 11/2/09. I want the data from
B4 to go to C15. so C15 will be 10/20/09. Then when I change B4 to 11/16/09,
I want C15 to automatically update to 11/2/09 and C16 to update to 10/20/09.
and so on for 5 dates.

Is this possible or do I have to manually keep doing it?

Thanks