Code to insert fields onto existing worksheet

Hi...I need some help with vba code please. We get a worksheet each month where columns A to E are populated but the number of rows will vary each month. What I want to do is to run a code which will add another 5 fields (columns G to K - column J is a formula) with the colur formatting in each column.
As the number of rows will vary I need the correct number of rows to be added to the inserted columns. On the last row I also need to have a total for each column. The user will manually populate the added columns. I'm attaching a sample file to make it easier to understand what I'm after.
Any help would be appreciated. Thanks

Thanks for your valuable contribution!

I'm hoping to learn that is why I'm posting a question so I know for next time.

This may be a simple task for you but it isn't for me.