You should be able to generate the code for this using the macro
recorder. Start recording, then:

1. Go to the source sheet  and select A1
2. From the Edit menu, choose goto - special - current region
3. CTRL+c to copy to clipboard
4. Go to the destination sheet and select A1
5. CTRL+v to paste
6. Now sort  as you wish

Now stop the macro  recorder and you should have a macro which does what
you want.