Hi, welcome to the forum.
I would add an Admin sheet where you place the list of users (usernames) and give each a ranking level, 1,2 3 etc.
Depending of which level the get to see / use / access what they have the right to.
A workbook and worksheets can each only have one password.
So X passwords for X number of Worksheets (unworkable for maintenance) and only ONE workbook password, only options are allow to open read only or with password for editing