This probably can't be done but here is my task:

I have a workbook set up for sales leads. There is a seperate worksheet for
each salesperson where the boss enters leads distributed for them. He wants
each of them to be able to update their sheet ONLY. Problem is when a
salesperson opens the workbook, he doesn't want any of them to be able to SEE
anyone ELSE'S worksheet (their own worksheet can be seen only). Those of us
in administration would however be able to see ALL the worksheets immediately
upon opening the workbook.

I'm stumped.