I have a maser work sheet with names alphabetically ordered. as well
these names are linked to worksheets based on departments


abarham---------hr worksheet a1
anderson--------it worksheet a2
billings -----------hr worksheet b2
..
..
..
zintel ----------it worksheet a1

now if i add a new employee at the bottom and sort the master data
everything gets shiffted is there anyway to get changes to the master
worksheet to update the child worksheets?
vba /macro