Data transfer from one workbook to another

[drop05]

Any help would be greatful!
Looking for a way using python or VBA to basically transfer data from workbook one to workbook two. The yellow cells and the light grey cells are the areas where data will be put into. I know it may show two rows, but the user is able to have multiple. As you can see there are some descriptions that are the same like name address etc, one workbook has more than the other.

So im trying to get it to basically have the user select which two workbooks to be the sources one to get from the other to paste into with similar landing spots. With that it is only from one sheet in each workbook. Then get the data from wrkbook1 to workbook 2 and everything to the right of it since the can have multiple names, address, etc, which can be 1 to 100 to 1000 cells to the right/.. Any ideas or ways to do so? There is more areas below but something to get started. Thank you!

Workbook 1

workbook 2

 

[XLfriend777]

Hello drop05. I just tried this for another post and it may help you get started. Try the following code which copies from Test1.xlsx to Test2.xlsx. Hope this helps and good luck!

Sub CopyPaste_Test()
'Note: Assuming both Test1.xlsx and Test2.xlsx are open workbooks
    Windows("Test1.xlsx").Activate
    Sheets("contacts").Select
    Range("C5:D14").Select
    Selection.Copy
    Windows("Test2.xlsx").Activate
    Sheets("register").Select
    Range("C5").Select
    ActiveSheet.Paste
End Sub