Making a Team Work Schedule

[Chaoticserph]

I am trying to make a daily station schedule for my team across a four quarter shift. Each associate rotates to a new station every quarter. I'm thinking that pivot tables are the way to go, but correct me if I am wrong. I insert a pivot table as a filter for each station for each quarter to create the schedule. What I want though, is for when I select one name for a station, it removes that name from the other tables for that quarter and also the table for that particular station in the subsequent quarters. Any advice or help would be appreciated. Thank you!