Extend formula when adding a column

[excelingtoexcel]

I am trying to see if there is a way existing formulas can include any new columns i add. I have attached a sample workbook. Essentially, i want to add a new column before column G and i want column G, which has the formulas to include the values i enter in the new column so that i dont have to manually update the formulas daily. I have included the formulas i have configured in column G into column H for ease of visibility.