Are you saying that you have a separate dashboard for each sales rep?
(You might be able to have just one dashboard and filter to the appropriate sales rep, but I'm guessing that you've already investigated that approach and have decided to have x-many dashboards.)
How are you navigating to the specific dashboard? Perhaps you could have a filter action when navigating the user to the appropriate dashboard, and in doing so, the correct rep can get passed to the sheet. Same sheet on all the dashboards.
Appreciate the quick response! I was able to figure it out by removing the filter I had for sales reps, and adding sales rep to the columns.