I have a workbook with 3 worksheets. In column A of wksht 1, I type employee
names. In column A of wkshts 2 and 3 I have = to then the cells in wksht 1,
so I only have to type the names one time.
So when I add a new employee it automatically adds it to the other pages. My
problems is when I sort the names into alpha order. I need other columns in
wkshts 2 & 3 , to follow the sorting of names.

Is there a way to to do this?