I am creating a dashboard and am trying to figure out how to have a feature where if the user clicks on an agent name, a pivot table with their data will "pop-up" alongside of it. On the left would be a list of agent names and the space to the right of that list will be saved for the pop-up pivot table. Once the user clicks on another agent's name, the previous agent's pivot table will disappear and the new pivot table will take it's space.

Can anyone help?