The file has two worksheets.

Sheet one will be sorted and Sheet two will remain static.

Column F in Sheet two is reading the values from Sheet one in column F
(you can see the forumula in column F sheet 2) (For Ex:
=SUM(Sheet1!F2)

As an aside, "SUM" is doing nothing here since there's only one number in
the sum. I'd suggest simply =Sheet1!F2 for clarity.


For example, if I sort sheet one (any column) then Sheet 2 does not
remain static and the integrity of the data is lost. What happens is
Sheet 2 column F will change but the other columns in sheet 2 don't
change and the integrity of the data is lost.

It's often the case that there's a "key" column that identifies the row
uniquely; for example, an account number or a part ID or a date or
something like that.

If your spreadsheet has a column like that and it appears in both sheets,
then read about the VLOOKUP function in Excel's built-in Help. Used in
Sheet2!F2, it'll find the value in Sheet1 column-F that has the same key
value as the current row.

For example, if the key column is A in Sheet1 and B in Sheet2, try the
following in F2 and copy down:
=VLOOKUP(B2,Sheet1!A:F,6,FALSE)

Modify to suit.