Macro to transfer column to row on another excel [Closed]

Hi All,

Was stuck on this for a few hours yesterday. Read a few threads with solutions but I kept getting a debug popup window.

I'm trying to transfer all data in Column D in Book1 into a new row on Book2. The macro would be imbedded into a button at the end of Book1.

Can someone please help? thanks!

Book1 -
Book2 -