when worksheet is sorted the corresponding cells or the cells linked to the
right, don't move with them. they stay in the same spot. Also this is a big
work group with worksheets that are linked and referenced together....