I have a workbook that is made up of sheets for each salesperson. The boss
wants them to be able to open the workbook and edit their sheet ONLY. On top
of that, each salesperson would only be able to SEE their own sheet (all
others would be hidden from them) but when Admin opens the workbook, THEY can
immediately see ALL the salespeople's sheets.

Is this even possible? Thanks.