VBA copy last row of a sheet of a workbook to last row of sheet in another workbook

[megaheinz]

Dear Logit, thank you very much for the quick reply.
The macro code works as such but it copies in my case the data to row 33 in the destination workbook and corresponding sheet and further and not row 14 (starting with D14).
I can shift normally the data put below the first table where the data should be copied.

Furthermore: is it possible to keep the SOURCE workbook closed and to insert the macro in the opened DESTINATION workbook?