Example: My workbook has two sheets:

Sheet One: Contains typed employee names in Col A. Col B is a pasted link
from a column in Sheet Two.

Sheet Two: Col A is a mirror of Col A in Sheet One. It contains pasted links
from the names in Sheet One.

In Sheet Two, Cols B-M (labeled Jan-Dec) contain hours worked in each month,
followed by Col N which is the sum of Col B-M.

The sum in Col N in Sheet Two links to Col B of Sheet One.

Heres the problem:

When I add a name to the list in Sheet One, then sort, the name list in
Sheet Two sorts OK, but the hours do not stay with the original name.