Dynamically move data from a table to another in excel vba

[superman_akrt]

Hi,

I have two tables in two different worksheets under the same workbook.
Table 1 & Table 2

1. I want to create a function that will take table 1 & table 2 as parameters.
2. Copy cells from table 1 to table 2 but we have have 2 questions:

Which column to update and which row to update to know the proper cell.
Which column should be based on the naming of the column example:
Table 1.Column 1 will be Table 2.Column 1 So detecting the column to update will be based on matching column names.
Which row should be last row in table 2 + 1.
So whatever the number of columns is there, function should search and match in table 2 based on column name.
I don't need exact syntax, I just want to know the how would the logic go.

Thanks,

 

[superman_akrt]

Any hope to get this answered