I am trying to find a formula that matches the "Names" from my summary sheet
to a separate worksheet and if the names match, bring back the most recent
date for that person.

Summary sheet(requires formula):

09/10/2008
Name Yesterday's numbers
AAA
BBB
CCC
DDD

Table to pull data from:

AAA BBB CCC DDD
09/08/2008 26 27 28 29
09/09/2008 30 31 32 33
09/10/2008 34 35 36 37
09/11/2008 38 39 40 41
09/12/2008 42 43 44 45
09/13/2008 46 47 48 49
09/14/2008 50 51 52 53