Copy and past rows from one workbook to another - VBA

Hi Team,

I have a requirement where I need to Copy rows from one workbook and past into last row to another workbook by Removing blank rows from from source column.

Can someone help me with the VBA code for the same.

Thank you!

Regards,

Sumit K