Autofilling formulas from a table to a new column added to the table

I have a button that creates a new column at the end of my table every time the button is pressed. I would like the last column of my data body range of my table to autofill the new column that is created when the button is pressed. I have spend countless hours trying to get this to work and have not succeeded. Here is the code that I have been working with:

With Sheets("Competitor Comparison").ListObjects("CompComparisonTable")
    .ListColumns.Add(.ListColumns.Count + 1).Name = Range("C2")  
    .ListColumns(.ListColumns.Count - 1).Range.EntireColumn.Copy  
    .ListColumns(.ListColumns.Count).Range.EntireColumn.PasteSpecial Paste:=xlPasteFormats
 End With

Does someone know how to achieve this?

P.s first post ever on this site

Here is my sample. The "Instructions" tab is where you type in a new competitor. The button creates a new column in the other two tabs. The "Competitor Comparison" tab is the place where I want the formulas to autofill over to the new column added. So everytime a new column is add, the formulas should fill the new columns.