Need help on automatic sorting

I've got a file with several worksheets and I need to have an automatic sort (descending) for different parts in several columns and this should be working for all the worksheets.

In attached file the areas to be sorted are in yellow.

Could please somebody help me out with this problem.

Many thanks in advance