Copy data from 2 external files into separate worksheets of a third file

[kevinbradley57]

I have three Excel files: SearchResultsInProgress m.d.yy, SearchResultsCompleted m.d.yy, and Weekly Plan Status m.d.yy. The Weekly Plan Status has 2 worksheets/tabs, "In Progress" and "Completed".

I need to do the following:
1) clear all data from the Weekly Plan Status file but not the formula used in column H
2) copy all data except the header row from SearchResultsInProgress m.d.yy to the corresponding cells of the In Progress worksheet
3) convert the data in columns K-N to Number format in order to remove the parentheses and insert a negative sign prefix (it defaults to "number stored as text")
4) copy the data from columns A-G (not header row) of SearchResultsCompleted m.d.yy to columns A-G of the Completed worksheet


5) copy the data from columns H-K (not header row) of SearchResultsCompleted m.d.yy to columns I-L of the Completed worksheet
6) convert the data in columns I-L to Number format in order to remove the parentheses and insert a negative sign prefix
7) copy the formula from H2 to all used cells in column H (the formula is =F2-F2)
8) open a new Outlook email and attach the Weekly Plan Status m.d.yy file

All of the above must maintain the cell formatting in the target file except for the conversion to Number format of steps 3 and 6.

Thank you!