Remove Un-Necessary Data by VBA

Hi All Expertise,
i have to make a report multiple times a day and it takes too much time because it has different steps pls provide a VBA code to do it automatically by single key or button. Step wise description:
Step 1. I go to first data sheet select from (C17:AN17) to 1 row # 1000 then copy it and paste in a new worksheet.
Step 2. I select 2nd data sheet from (C21:AN21) to last data row which will be between 1 to 1000, copy it and paste in that sheet where i paste 1st sheet data. (Below that data).
Step 3. Delete Row# 2 & 3.
Step 4. Delete Columns (TOTAL PCS, SHRINKAG, Width, Shade, Balance & all blanks columns).
Step 5. Copy data from (D1:Last data cell) and paste in Row # 2.
Step 6. Delete Row # 01.
Step 7. Insert Filter. Open filter in column C and delete blank rows.
Step 8. Delete column C.
Now I have only that data which I require.
Step 9. Unpivot Columns. (I have VBA code for it)

Please Login or Register  to view this content.

Step 10. Some cuts have more than on value row assign them numbering. (I have VBA for this

Please Login or Register  to view this content.

Data Sheets may be 1 to 15.

Administrative Note:

This is the third offence. As you seem not to care about our rules, I am issuing a 10-day timeout to give you time to read them and accept them. If you continue to ignore them after that, you will be banned permanently.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)