I've seen some similar postings but not specific enough.
I have a master worksheet with a lot of data. There are four sub area
worksheets that are blank. All data is kept on the master. Data only goes
into a sub worksheet as needed, so all data does not go into all the sub
worksheets.
All worksheets have one common column that has a unique identifier for that
row of data.
I need to be able to take the unique identifier from the Master worksheet
and enter the identifier on a sub worksheet and all matching column entries
for that identifier's row to enter on the row on the sub worksheet.
Also, if the same data is on a row in the Master worksheet and on a row in
a sub worksheet, both rows with the unique identifier, as a change is made on
the master it changes on the sub worksheet.

I know this is complicated and would probably work better in Access but I
have to look at who the end users are.

Thanks in advance,
Ken