Hi,

One way would be to have a very hidden sheet, i.e. that couldn't be unhidden from the application only from the VBE. In that sheet you would have a list of supervisor names and their passwords and for each supervisor a list of their sheets.

All other sheets would be similarly hidden apart from an Introduction sheet. This would contain a single drop down cell which would allow the user to select a supervisors name. On selection a pop up box would prompt for the password. This would be compared with their allotted pw and if correct the relevant sheets would be unhidden.

That's one way although without workbook sharing, and as Ron implies I would steer well clear of that for reasons we won't go into here, only one person can update it at a time.

The other way is to have a workbook for every supervisor and have a consolidating workbook that would gather all the data from the individual workbooks when a macro was set running. You'd end up with the same result but arguably it will be more flexible than having supervisors fighting over access to a single workbook!