Macro To Sort Automatically

I am now trying to write a macro which is a little over my head and was hoping some one may have some idea how to do it or have some code that is similiar and I can try to customise it myself. So here goes.

Basically all that happens is I paste data into a work book that always has two columns. The first column is a list of names and the second column is a list of numbers. I need to sort that information automaitcally every time it is pasted into the work sheet as follows.

1) Once any information is pasted to sheet 1 run macro automatically with no user interaction

2) All numbers must be rounded up or down first before sorting. If it is say 2.4 then it would become 2 and it it was 2.6 it would become 3.

3) Then move the numbers only from a specified column from sheet1 to sheet 2 and split them up into seperate columns based on the following results.

a) 0 - 3 gets moved to column B
b) 4 -7 get moved to column C
c) 8 - 10 gets moved to column d

4) Delete both columns from sheet1 after this is run so the user can re paste new information

5) If a user does this again then do the same but move into a new set of columns e f g and so on until the work book ends.