Preliminary question: I'm assuming that each of the three salespeople have their data on a separate worksheet of their own. Do you want the master list for the boss to be three worksheets in one master workbook, or all combined in one worksheet with some kind of header row for each salesperson?