Display only one location in Pivot and select available location users

In the attached document provided I have the following:
1. Locations 1 through 4
2. The users in all location
3. Their projects completed, inspected, and the percent of the accuracy

I have the data and the pivot worksheets.

I want to setup a ODBC connection to the data located on the sharepoint. I know how to do this. So the "Data" sheet included will not be in the spreadsheet I provide to each location.

My issue is, I only want to give each location access to their location details only. So if I setup a spreadsheet for location one to view their stats, they wont see any other locations or users.

Is this possible through some script or formula?

I need my user to be able to select the user from the dropdown within their location, and which months they want to display, so tey can go over errors with their workers, which is why I chose the pivot.

Thank you