Excel 2010 :: Create 3 Or 4 Detailed Reports From Worksheet?

I need to create 3 or 4 detailed reports from an excel 2010 worksheet.

My worksheet contains data including date, invoice number, company , consultant, days, dollars. There are approximately 100 records in the worksheet.

Requirement 1 :I want to use excel 2010 to automatically generate a series of reports broken down by consultant showing date, invoice number, company, and consultant with totals for days and dollars, when all the records for consultant 1 are listed, then I want to show consultant 2.

Same for any other consultants with a grand total at the end.

My understanding is that excel 2010 makes this process very simple .