Macro to group and sort data rows

[hellothere1234]

I have rows of data that I have sorted by Date and then Employee. I want a Macro / VBA code (not a Pivot table) that can:

1) Group the rows into separate weeks (Tuesday to Monday) and add 2 rows between each group
2) Resort the groups by Employee then Date
3) Add a row at the top into cell B1 with value 0.06
4) Sum the invoice totals in row A at the end of each group
5) Enter value into the right cell of that sum multiplied by cell B1 value.

I've attached snippets of my worksheet here to show what I currently have (https://imgur.com/KARf8AF) and what I hope to achieve (https://imgur.com/Q9ykp0H).
Thank you all for your help in advance!

 

[alansidman]

Cannot manipulate pictures to test macros. Time is money and I don't have much of either to try and replicate your sample. Suggest you upload an actual sample files.