columns on worksheet2 don't sort with worksheet1

While the linked column on worksheet2 does sort, the related non-linked
columns need to sort with linked column. Else, we need to figure out how to
not sort linked column on worksheet 2 when sorting worksheet 1.

If you're intending to sort a list/datatable, then you shouldn't have any direct linkages to/from cells outside of that list/datatable. This would be asking for trouble.

If you do need to pick up information from cells which are in a list to be sorted, then you need to use formulae which do not depend on the order in which the data is stored (by rows) within the list/datatable.

An example of a satisfactory link into a sortable table is a Vlookup on the values in that table.