Excel VBA - Form Controls on Worksheet

I have a form in a worksheet with several text box inputs(ActionItemForm). When I click AddActionItem button, I want it to fill in the data in the second worksheet(ActionItems).

The data in the second sheet is also pulling in values from a third worksheet so the columns aren't Contiguous.

The second sheet holding the values includes the following columns(ActionName, Description, Resolution, AssignedTo, Team, Status). I've found ways to add a new action item to the first row by using Get/Set method and named cells but, I haven't been able to add additional action items to the range(s). AssignedTo and Team are pulled from a seperate worksheet, I'm just trying to get the action item values right now. This should be able to hold 1000 action items and I should be able to retrieve these values to populate an update screen at a later date.

Thank you for any help you can provide. This is for a school assignment.