Append a new record to a single column range

So, I've been trying to figure this out for awhile now, and I haven't had any luck.

Problem: I have a user form that has 3 text boxes each with their respective button. Each text box is designed to allow a user to enter some text and then click the button to update a specific column. The specific column that is being updated/appended is used to populate drop down lists within a worksheet. The idea behind this is to allow the user to maintain the list with new values as needed without having to unhide the lookuplists sheet. The caveat here is there are several single column named ranges that are in one sheet and they are all different row counts.

The objective: Each text box points to a different column that needs to be appended based on a button click, how do I do that.

Details: each named ranged is a single column formatted table within a single sheet (example below)

A	B	C
1	1	1
2	2	2
	3	3
		4

Scenario: User wants to add a new value to name range A in order to show up in the list drop downs. So they launch the user form, enter a new value, let's say '3', and then click the button. I'd like the action to be that the value in the text field is appending to named range A. What I do not want is a row to be inserted across the entire sheet thus adding a blank space to named range B and C. You can use a similar example for the other named ranges where the value in the applicable text box should be applied to that column and that column only.

Submit your workbook.

See the attached.

My userform is launched via the button on the Fuel Economy Stats sheet. On the user form, I have three text fields off to the right where I would like a user to be able to enter a text value and click the 'Add New' button for the respective text field and have it update a named range.

The named ranges are located in the 'LookupLists' sheet. Each column is formatted as a table and is a single column wide, but vary in row length.

Payment Type text field > PAY_TYPE range
Brand text field > BRAND range
Fuel Type text field > FUEL_TYPE range

So in my ideal solution, I'd like just the respective column to grow one row, at the end, with the new value. The blank cell in each named range is there to represent a blank selection in the list for the drop downs on the Fuel Economy Stats sheet.