Auto add rows in a table when information is input in different table

Hi all,

I am looking for VBA that automatically expands table 1("F - plan) only for position once new value is entered in the yellow table from sheet "Reference".

I am not sure if the below is making any sense. However, i think that some conditions are not met.

Sub AddName()
    Dim NewRow As Range
    Set NewRow = Range("Table1").EntireRow(Range("Table1").Rows.Count).Offset(1,0)

    'Excel will include the newrow into table automaticlly
    NewRow.Cells(1, 1).Value = "newvalue"
End Sub

Thank you in advance