Control Button Macro to Expand a Cell and Add New Rows

Hi All,

In Table 1. I have a lot of duplicate data. I would like to be able to insert a control button with a macro that adds rows onto Course Name, Start Date and End Date and expands Name, Staff No. and Staff Group each time Joe Bloggs completes a new course.

Table 2. is the desired outcome which I completed by merging.

Can you help me with the VBA code to branch one cell into multiple cells that are all linked.

Any help is greatly appreciated.

D.