Sorting and Copying to a new sheet based on values

Morning All,

I have a worksheet that contains grades for a group of students called "Grade Reading"

What i need to do is have a macro or formula that will sort the data based on column L.

Then copy the ID in column H from "Grade Reading" and paste it into a new sheet based on the value of column L "Grade Reading".

Then to add another layer colour code the cell based on the growth in colum O from "Grade Reading" in the new sheet.

ANy help would be awesome

If I understand correctly then sheet1 of the attached file does what you want.
The student's ID is placed using the formula: =IF(B$1='Grade Reading '!$F2,'Grade Reading '!$A2,"")
Three formulas set the rules for the conditional formatting.
Green: =AND(B3<>"",$A3-B$1>0.5)
Amber: =AND(B3<>"",$A3-B$1=0.5)
Red: =AND(B3<>"",$A3-B$1<0.5)
Note: Row 1 of sheet 1 may be hidden for aesthetic purposes.
Let us know if you have any questions.

Not sure that I understand what you mean by 'top down', however if you mean in alphabetical order then sort either column D or K of the Grade Reading sheet in ascending order. The change should carry over to Sheet 1, or at least it did when I tested with the file attached to post #4.
Let us know if you have any questions.