Copy-Paste Column to another worksheet

Hello,

I created a macro that will create a worksheet and create headers and now I want a column of data to transfer into another worksheet with the same header respectively, but my code is not working

I've attached the excel that I've been practicing on.

Please Login or Register  to view this content.

I have no idea how to put those codes together

Thank you for anyone who will answer

Try:

Please Login or Register  to view this content.