Replicating data from master sheet based on 2 criteria

Thank you for reading my post, I could really use expert help on this!

I have a master spreadsheet created to track expenses (attached). Each line of the spreadsheet refers to an expense, and each expense is assigned a "Division" (ex. A, B, C, D, E) and Region (North America, Latin America, Europe, ME&A, or AsiaPac). I need to build functionality into the spreadsheet whereby various users can open the spreadsheet and have read-only access to just the expenses they have incurred for their Division and Region. In other words, I want Mr. Smith to be able to see only expenses for Division B North America and nothing more. This creates of combination of 25 divisions and regions, with 25 users who need to be able to access read-only data on their division and region.

Can someone give me an idea as to the best way to accomplish this? I have considered Pivot tables, IF statements to force an expense line item to a certain tab then password protecting each tab, etc.

I know there has to be a better way to do this, but I am at a loss for what to do and am running into a project deadline on this.

If you're able to propose a solution, can you please provide guidance on how I can accomplish what you suggest?

Your help is MUCH appreciated!

How do you identify that it is Smith who has opened the file? If we are able to validate the credentials of the person opening it, then based on the credentials, the data for that person can be copied into a separate sheet and all the other sheets can be hidden.

Originally Posted by arlu1201

How do you identify that it is Smith who has opened the file? If we are able to validate the credentials of the person opening it, then based on the credentials, the data for that person can be copied into a separate sheet and all the other sheets can be hidden.

Those accessing the database would presumably be identified by their company-issued userid (Jsmith) which is their email address and allows access to company networks - does this make sense and can we work with that?