I am producing league tables at work and different viewers can see different
things

Each user needs to see all of the income for each person on the league table
but should only see the names, job titles and locations of their own
consultants.

To illustrate, the manager of a branch should only be able to see the names
of the consultants in their branch but the income for everyone.

The regional manager should be able to see the names of everyone in the
branches in their region but the income for everyone

The area manager should be able to see the names of everyone in the branches
in the regions in their area but the income for everyone.

Is there a way I can set the spreadsheet up so this happens when people log
in, or do I have to save off various different spreadsheets with only the
data they should see in there?

Thanks in advance for all advice!