Multilevel Lookups for a dynamic table

Hi all,

For simplicity sake lets say I have a 3 column table (Name, date, status). How would I sort for the most recent entry (date) for a name (could occur multiple times in "name" column) and extract status to a different table on different worksheet? Id like to use no data dumps; helpers; extra columns; extra sheets; etc?