Insert Row in excel table based on text input in a cell

[SUR1984]

Hi All,
I need a VBA code to insert a new row in my excel table if any text is inserted in a designated cell.
My excel table is in a sheet with name "Reference #" and the new row should be inserted in Row 7 of this sheet.
The designated cell is in sheet "Data" with cell reference B2:D2 (Cells are merged).

Basically, the objective is whenever someone enters a project name in the designated cell, excel automatically updates the excel table in my "Reference #" sheet.

Thanks in advance
SUR

 

[SUR1984]

Clarification on requirement:
Please note that the designated cell will not have any specific text, it will vary based on user input/project name.

 

[SUR1984]

Re: Insert Row in excel table based on non-specific text input in a cell

Clarification on requirement:
Please note that the designated cell will not have any specific text, it will vary based on user input/project name.