Need sample for generating excel 2010 reports from worksheet - Please help

[BobT515]

I need to create a series of 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

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

Can someone show me man example of how to do this PLEASE

Need to generate this report today - if at all possible

Thanks Bob T