I have two worksheets in a workbook. One of the columns in worksheet 2 is
referenced to a column in Worksheet 1 (i.e. cells containing peoples names).

When I sort Worksheet 1 on the cells containing names it also sorts
worksheet 2.

Is there a method to NOT sort the worksheet 2 when I sort Worksheet 1?