Hi I'm trying to make a spreadsheet that tracks client contacts. Sheet one has all the clients on, name, local etc. with date and time and contact type ie. phone, direct
etc.

what I want sheet 2 to do is list the clients every time a change is made on sheet 1 to the time and date
so sheet one would be something like this but with more data and show only the last contact made only

joe blogs acme 10.00 25/12/13 direct
fred nerk abc 09.30 27/10/13 phone
betty davis hhh 11.45 21/06/13 phone

sheet 2 would generate list showing all the available contacts
joe blogs acme 10.00 25/12/13 direct
joe blogs acme 12.00 02/10/13 phone
joe blogs acme 10.00 15/11/13 direct
betty davis hhh 11.45 21/06/13 phone
betty davis hhh 14.45 15/06/13 direct
fred nerk abc 09.30 27/10/13 phone

I would like to do this without any vba if possible as i have no idea how to use it.
thanks
d