HI
I'm trying to write a code that will allow me to autosort data

The data is updated every second automatically

The data is displayed on graphs and the sorting rearranges these graphs to keep them looking right.

I have 3 different work sheets doing this
worksheets 1, 2 and 3 column headings:

A - Company Name
B - Code
C - Price 2010
D - Price 2011
E - Current Price
F - % Change

There are then a couple of rows gap and then the data starts
Worksheet 1 has data from 4-7 inclusive
Worksheet 2 has data from 4-23 inclusive
Worksheet 3 has data from 4-11 inclusive

I want to sort Column F (%change)

a lot of the values in "F" are negative, some are positive if this makes a difference

Obviously, I need the whole row to move as the F value changes as all the data is linked