How to maintain the formula driven cells values while sorting

Dear All

I have a set of data in columnar format where each cell in each column is linked to my source-data sheet by a formula. Some of these formulas are straight links (i.e. cell address in the source-data sheet) and some are through INDEX function converts either columns values to rows, rows to columns, or linking columns data in reverse order to certain rows.
When I try to sort on one of the column's heading, the data is sorted but instead of maintaining each cell's value, I get unexpected values.
I have tried to copy the data and paste as values (i.e independent of formulas, just containing the returned values) and then sort. it worked well. But, this is a manual step which I am trying to avoid.
What sorting options are available while cells are linked to the source-data? I appreciate your assistance.

Thanks
Simon