Macro help! Clear the content from the selected cells & delete the selected rows

Hi.

I have been working on a file and wondering if a Marco could help!
Basically, each time I need to clear some content & to delete some unnecessary datas in the C column. Finally, re-present it as a clean easy to ready report.

1. insert a new colunm after C columnn and name the new D column as " Color".
2. I will bring cell: C6 to cell: D4
3. clear the data from cell: (A5:D9)
4. delete the blank Row 10
5. Fill the data from (A5:D9) with the same data on Row 4

repeat the above 1-5 steps for the next item.

I'm attaching a sample file to show how the original file look like "before' and what is the desire "result" to be.

thanks for checking and all the help!