Sounds like what you need is a dynamic user filter! (Create a User Filter and Secure it for Publishing). In short, you can achieve this by creating a security table that maps users to the groups they should see. You can JOIN that to your main table to have the mapping setup. With that you can create a calculated field that evaluates this mapping, something like:
USERNAME() = [UserInExcelSheet]
You can also extend that expression if you know a user or set of users should always see everything. For example, if 'Admin' should see all:
USERNAME() = [UserInExcelSheet] or USERNAME() = 'Admin'
Drop that calculated field on the filters shelf (or, even better, as a data source filter) and select TRUE. The view now only reflects the groups described on excel, unless you are the administrator.
This blog explains more of this in detail: How to set up your Database for Row Level Security in Tableau | Tableau and Behold!
Hope this helps!