Move Data to specific table on same worksheet depending on cell value? (VBA)

[8BITADDICTION]

Hello,

I am working on an import document for my work and have been struggling with the other members of my team moving/editing/deleting information that the document has to reference to successfully import the information.

So I am trying to create a table where someone can come in and fill the information they need added there, select the table name and then click a button to have that information moved to the appropriate table.

The tables all have a reference column that would need to be ignored.

all of the tables are on the same sheet called "Lookups" and all have their own unique names.

Am I asking too much of VBA, or is this possible.

Any help would be appreciated. I apologize if I am not super clear on what I need, this is my first post here and I am not familiar with VBA to the extent that I would like.

Thanks.

 

[8BITADDICTION]

For an example: say you need to add a new Line of Business code to the tool.

You would add the Client name, Language and the Code, then select the table called "LOB Group Code" and then hit the button. That line will be moved to the selected table in an open row. if there are no open rows, it will create one.