I have two work sheets. The first contains a list of clients while the second
records data on each occation we have a contact with our client. I want to
extract data from the second sheet that reflects the most recent entry. It
look like this:

Sheet 1
Client Ref First
Number Number Name Last Name
1 654 Sam Fisher
2 123 Sam Jones
3 688 Harry Smith
4 478 John Johanson

Sheet 2
Date
Voucher Client Centre First Last
Issued Number Ref Name Name
15/08/08 1 654 Sam Fisher
15/08/09 1 654 Sam Fisher
15/08/09 3 688 Harry Smith
15/08/09 4 478 John Johanson
15/08/09 5 987 Laurey Dessmond

As you can see client #1 has an entry on 15/8/08 and 15/08/09.
I need a formula that can return the latest date into a cell in sheet 1.

Is this possible? Please help.

Thanks