Creating a data entry form to add a new row with merged cells

[horizonblue]

Hi!

I am creating our yearly leave calendar for our employees.

We want to be able to create a data entry form, where we enter in the employees branch, employee name and employee ID and it add a new row, I've attached a screenshot of our spreadsheet so far. However we have merged cells.

If we are wanting to create this data entry form to work with our merged cells what would be the best way to do this?

We are wanting to form to look like the image below.

Thanks!

EDIT:
It'd be amazing if I would be able to create a function where I can delete the row once the employee resigns easily too.