Insert and Delete questions and answers using macro

[meetgilbert]

Hi Team

In Sheet "Test" I have the questions and answers. In sheet "Modify Test" I have placed two shapes named "Add questions" and "Search and Delete"

Sheet "test" will be hidden. The user can access only sheet "Modify Test" where he can add question with answer by getting input based on the lesson type accordingly the row ahould be inserted and also delete a question with answer.

Now once the details are added, the other formulas should be automatically applicable to the added rows.

I have attached the excel sheet.

Please check and give me a macro if possible.

Thanks in advance for your time and effort.