Desperate in need of help with VBA macros

[Tocix]

Good afternoon Gurus,

I serached forum and nothing came up close to this. I have workbook with sheet1 and sheet2. I have hundred of rows of data. I shorten it in the example in the link. Please help me out with creating macros that would copy sheet2 to sheet1.
Example on sheet2 column D storage "D" copy all rows and columns A,B and C to sheet1 on column AB and paste it to Y,Z and AA.

https://1drv.ms/x/s!AlmkdS7ztCFqaegYjRNOH4FW8tQ?e=EksjXb


Thanks in advance