Great tools, but I have a problem...

Here is an example of some data I want to sort. The value are pulled from other sheets using forumlas. Notice the tallies are not in order. http://screencast.com/t/YmNmNDNmND

Now here is how I am attempting to sort the values: http://screencast.com/t/OTY0ZjQyM2

Here is what the results look like: http://screencast.com/t/Nzc2YTg5
The cell coordinates in the formulas have been adjusted, and they should not be changed. Now they are pulling the wrong values from the other sheets.

The sort appears to be working correctly (the rows are now in the right order), but the cell coordinates have changed and are now wrong. This can be fixed manually by editing each cell and fixing the formula, but this is not an acceptable use of time ;-)  Please let me know if this can be fixed.

Thank you