Password protecting specific info in a file?

I have a master file with all the sales information for all the salespeople in the company. Because my manager doesn't want people to see everyone else's info, what they do today is copy and paste each person's individual info in a new file and send them their file. This not only messes with the formatting and formulas, but it's really time consuming.

Is there any way to protect the whole file so that we all use the same master file, and if for example John wants to see his info, he enters his specific password or command so it unlocks only John's info? And then if Jane wants to see hers, she has her own password or command and can only see hers?

It's all just one big table so essentially what I want is to be able to filter by the "Account Manager" column, ensuring only the desired person's info is available even if they try to remove the filter.