This is a little hard to explain so I've uploaded a file so hopefully somebody on here can help me resolve this fairly quickly!
(Click here to download)


Now let me explain what I'm trying to do.

I have several sheets
1) Groups: This is where all the groups and users are
2) Section Master: This is where all the user's will be put to their sections
3) Section 1, 2, 3 & 4: This is so each section can view where their users have been placed

What I'm trying to do:
If a user is moved section it needs to be changed on their corresponding group.

So, If User1 (who belongs to Group 1)is moved from Section A to Section B then on the Group 1 sheet the user needs to be moved to the selected area.

Fairly hard to explain unless you have the sheet to understand.

But the Section Master sheet can be the only 1 filled out then all the people who run the groups just need to look at thier groups to see what each person will be doing.

So is there anyway I can link cells across all sheets but only display the groups?

(Easy way to understand, If I have a master calendar with all the months on a sheet and I enter data into say Feb 14th then at the bottom i have sheets, Go to the February sheet and on the 14th the data will be there)

I know this might be hard to understand but if anybody can help it will be very much appreciated!