Dear Experts,
I have a big excel workbook comprising of sales data for various sales person. Each sales person's data is maintained in separate sheet in the master workbook. At the end of sales date worksheet have the detailed data for every sales person. I want to create a summary of detailed data from each sales person in a SUMMARY tab. Detailed data is located in same column for all the sales persons, however the row position is different depending upon the sales data.

Detailed Data for every sales person
Sale (Item A) 80
Sale (Item B) 90
Total Sales ($) 1200

Expected summary
Sale (Item A) Sale (Item B) Total Sales ($)
John 80 90 1200
Richard 60 70 1500
Mike 20 40 800