How to have lists from a master sheet update other tabs

[barbara81906]

I have a master sheet that may get updated as employees change throughout the year. I want its lists to update the other tabs on the spreadsheet. all the other tabs are same layout.
master sheet as 3 departments that have a rotation of employees anywhere from 4 to 7 weeks then it rotates again. I want to be able to input on the other sheets that the south road shed is on week 1 and have those employees show up on that sheet and that central is on week 2 and north is on week 4 and then if the employees change I can just update the rotation names on the master sheet and have it update on the weekly sheet. so there will be 2 colums that move over one with names and one with their phone numbers (I just have the numbers hidden for the example)

Master sheet example

Weekly spread sheet example

 

[offthelip]

You might be interested in this thread which has a similar problem but it allows you to edit either tab:
2 way cell linking - multiple cells and multiple sheets
If you just want it one way then you can use just one half of the code