Require VBA Code for Summary Report

Hi Friends,

i m attached maindata.xlsx, anybody kindly send vba code for following report..
i need a lot of these report..
i have excel 2007 version.

PARTYWISE SUMMARY REPORT


PARTY ID- PARTY NAME-SALES-SALESMAN -AREA
P-001- AAAAAA- 138- SALESMAN-2- AREA-6
P-002- BBBBB- 211- SALESMAN-4- AREA-2
P-003- CCCCC- 140- SALESMAN-1- AREA-2
P-004- DDDDD- 49-SALESMAN-2- AREA-2
P-005- EEEEE- 87- SALESMAN-1- AREA-5
P-006- FFFFF- 17- SALESMAN-2- AREA-2
P-007- GGGGG- 37- SALESMAN-4- AREA-4
P-008- HHHHHH- 86- SALESMAN-1- AREA-2
P-010- KKKKK- 119- SALESMAN-3- AREA-4
P-009- JJJJJ - 20-SALESMAN-2- AREA-3
P-011- LLLLLL- 15- SALESMAN-2- AREA-2
P-012- PPPPP- 130- SALESMAN-1- AREA-2




SELECTED BRAND SALESMAN WISE CUSTOMER LIFTING

SALESMAN
PARTY ID- PARTY NAME SALES
SALESMAN-1
P-003- CCCCC- 16
P-005- EEEEE- 5
P-008- HHHHHH- 69
P-012- PPPPP- 10
SALESMAN-1 TOTAL 100
SALESMAN-2
P-001- AAAAAA- 77
P-004- DDDDD- 10
P-009- JJJJJ- 13
P-0011- LLLLLL 10
SALESMAN-2 TOTAL 110

Brand Total = 210

continue report upto all salesman end..

Thank u Sir, i know pivot but this is the format i want to show to the front and the future is to give all reports in the same format.

Thank you again sir..