Creating a tip-tracking spreadsheet. Using Google Sheets.

I’m trying to pull the latest information from one Google Sheet to another. The Detail sheet has columns GroupID, Name, Record, Invoice, and Date. There are several invoices and sales records for each Group, received on different dates.