Copy multiple column and paste in the template based on column headers VBA

Hi All,

I am a beginner in VBA and I need your assistance in fixing an issue. I have an excel template where I need to save all the data from multiple excel files which are stored in a folder. Both the files (Excel template and source files) have same headers and I need to copy only specific headers based on input.

I need to copy only the below headers as there might be an additional headers in the source files. The sheet name in the merge template is named as Results and even the source file has the sheet named Results from which I need to pull the data. Some times this sheet might be hiden and it wont be visible. So, everytime when the source file is opened, the sheet gets unhiden and then copy only the below headers and paste in the excel template. There might be multiple files in the folder.

Date Yes/No Doc Number Our Number Lot # Sup.Mat # ID Sup # Sup Name Desc Code Group Desc In Processing

Source file name is "File0918". There will be a lot of files moved to folder with different names.

Regards,

Rakul