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)

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.

If you like I can email you the file.

Hope that makes sense.

Please let me know how to resolve this.

Thanks
cmckeag