I need help sorting a table
 

HI ALL!!!

J25...1...K25...(randbetween(1,1000000))...
J26...2...K26...(randbetween(1,1000000))...
J27...3...K27...(randbetween(1,1000000))...

Now, on sheet3 I would like to create the same table only automatically
sorted by column K

Oh, and it would be nice if after ever change on Sheet1 (which causes the
randbetween function to act; changing the number) Sheet3's table will KEEP
the original value assigned to the cell.

ex. and desired outcome:

J25...1...K25...842643... (please note that once a cell has been changed
J26...2...K26...520924... all numbers in column K will change as well)
J27...3...K27...683921...


Sheet3's table would be:

J25...2...K25...520924...
J26...3...K26...683921...
J27...1...K27...842643...


ANY IDEAS???