Consolidate and password protect tabs

[Rabbit Car]

I am trying to create an employee performance evaluation workbook in Excel. Here's what I have in mind:

1. Each employee has an Excel workbook (e.g. Employee.xls);
2. Each workbook has different tabs for different managers to access (e.g. Manager 1 and Manager 2);
3. All managers enter scores for various questions on the tab for that employee (e.g. Manager 1 enters scores on tab 1 of Employee.xls and Manager 2 enters scores on tab 2 of Employee.xls);
4. Each tab is password protected (e.g. Manager 1 can only view tab 1 and Manager 2 can only view tab 2 based on their own password or based on their own username when they logged into their Windows?);
5. When all managers finish entering the scores, the data is consolidated (using the "Consolidate" function in Excel) into a summary worksheet in the same workbook for the owner's review.

Questions: Is the above doable? Can I still use the Consolidate function when each tab is password protected?

I have almost zero experience in VBA but I did have some programming training in college (such as C++ and Java but that was more than 10 years ago).


Suggestions and guidance will be greatly appreciated.