Automatically populate cells based on info in another worksheet

[Francis]

This is probably easy, but I just can't get it.
Here's the scanrio:
I have 3 worksheets: 1.Main(Contains info for 2 offices), 2. East
Office,3.West Office
I filtersd the Main sheet by office location and created the other two
worksheets.
What I would like to happen is, when I get an update on a room number, I'd
like to enter it into the Main worksheet, then have it automatically polutae
that info for the user in the other worksheet(either East or West).
Example: Joe Schmoe sends me info that his room# is 53. I enter that in
COlumn F in the Main worksheet and when I look in tye East worksheet under
Joe Schmoe, that info is already updated.

 

[Mindy]

It sounds like you could add a formula to say = whatever cell number from
your main worksheet.

 

[Francis]

Yeah, but I would need one that checks all the changes in the Main sheet. So
every update in the main sheet, would then update one or the toher East or
West worksheet.