Tab Privacy in Excel

Laura_Dez Excel protection was never intended to keep people from accessing sensitive information. If you do not want people to access certain information in a file, don't include that information.

What I would suggest you to do:

1. Create one workbook for everyone
2. Create a dedicated Sharepoint or OneDrive location for this
3. In that location, add a subfolder for each person
4. Allow access to that folder to only that person (and yourself)
5. Send everyone their personal link
6. Save a spreadsheet with just the tab for that person in his/her folder
7. Open a blank workbook, use Data, Get Data, From File, From Folder to gather the data from everyone into one master workbook only you have access to.