Separate protected worksheets feeding into one control sheet
 

Hi

We're trying to come up with a sytem whereby each operator completes his/her
own error log, where they identify errors they discover and detail what, when
and by whom. Only they can have access to this Excel document. Justy using
Protection will only prevent others from altering data, but not prevent
access. Only that operator's Line Manager should also access the sheet.

But I also want the Line Manager to have a control sheet which extracts
entries from their operators' sheets automatically.

Can anyone suggest a way of making each operator's sheet readable only to
themselves and their Line Manager and a way for the Control Sheet to draw off
data as it is input by each Operator in the Line Manager's team?!!!

Thank you.

Keith