HELP! Put data in ascending order but also need to move other cells at the same time.

I currently have a chart showing the weather (highest and lowest temperature in Celsius) of some cities for 7 days and the average for each day on the right. However, I am required to put the temperatures into ascending order. I am wondering whether it is possible to place the average cells into ascending order (which includes moving the two cells next to it with the average formula).

Excel Help.JPG

Please help this is an important part of my schoolwork.
All help is appreciated,

Bruce C

Hi Bruce
if you select the data in all of your relevant columns and sort on column E it should automatically sort your other columns as well, even if column E contains a formula

Thanks Nicky! That helped me a lot!