使用特定列名复制粘贴数据

I have a very basic knowledge and VBA but due to coding in other programming languages, I have a thought if I can copy-paste the data using specific column names in vba-excel. I use the following code till now but want to get over as I get stuck too often.I have a very basic knowledge and VBA but due t