Macro to Sort and Copy rows

Hi,

I have an excel template (attached) where in Sheet 1 there are 20 rows and 8 columns of data.
In the real excel however there can be 1000's of rows of data and more columns.

I want help in writing two different macros to:

1. Identify Top 10 items on the basis of Schedule Variance percentage and copy the rows to Sheet 2. But I don't want entire row. I want to copy till Schedule variance only

2. Identify Top 10 items on the basis of Cost Variance percentage and copy the rows to Sheet 3. Again I want to omit copying Schedule Variance column from Sheet 1.

Also, before copying the data, the macro should clear out the prevous data entered on Sheet 2 and 3 and leave the heading only. This would help at the time of repeat run and avoid duplicates.

Please find a template attached.

Kindly help

Regards
Paul