Do some Excel Work

Hi I need a VBA macro to be run when I open a formatted file (attached) which can have between 1 and 1000 rows. Actions: 1-delete column A (note the column name below are the current name in the sample file) 2-insert a column between I and J; Title of the column is Total; formula to be inserted in all cells of this new column: sum of H + I cells 3-insert a column between K and L; Title of the column is Total; formula to be inserted in all cells of this new column: sum of J + K cells 4-insert a column between M and N; Title of the column is Total; formula to be inserted in all cells of this new column: sum of L + M cells 5-insert a column between O and P; Title of the column is Total; formula to be inserted in all cells of this new column: sum of N +O cells 6-insert a column between Q and R; Title of the column is Total; formula to be inserted in all cells of this new column: sum of P + Q cells 7-insert a column between S and T; Title of the column is Total; formula to be inserted in all cells of this new column: sum of R + S cells