Hi All,
I have a spreadsheet (example attached) that contains multiple sheets, each with sales results from an individual client. A variable number of sales agents are assigned to each client. New tabs will be added throughout each sales quarter. Each client sheet has a table that may be sorted by various criteria: number of employees seen, number of employees sold, total premiums, total premiums per employee sold, etc.

I need to create a consolidated summary sheet that totals all the numbers from all sheets, for each sales agent, and allows sorting in a table similar to that on each sheet.

Any idea how to accomplish this? Thanks in advance for your reply!

EXAMPLE PERFORMANCE.xls