Here is the case:
I have 20 columns of data that is updated daily. On another sheet I
keep track of the largest data changes.

On the sheet with the data I have numerical values in F3:23. I want to
find the 5 highest absolute values and highlight the cell in a certain
color (color #23). I then want the numbers to be reflected in order
(negative numbers then positive numbers, NOT their absolute value).

Basically the setup is like this:
on sheet1 I have this:
Column A Column B Column E Column F
Name Date % Change Change
In rows 3:23

On sheet2 I need the data associated with the 5 largest absolute values
in column F to reflect like this:
Column A Column B Column C Column D
Name Date % Change Change

I need them to be sorted in order from negative to positive (I don't
want the absolute values here).


The highlighting of cells on sheet1 would be nice, but not necessary.

As is I need to do all of this by hand, and I would love a macro that
would allow me to automate the process. Considering it is something
done everyday, it would save significant amounts of time.