Copy specific columns from multiple files in folder and combine those columns in workbook

Hi Jindon,
I have added the column header still is not working.
for the second piece of code, i getting runtime error. It says problem with one or more formula references in this worksheet.
Is the code search for random columns in the attached sheet?

Hi Jindon,
Nothing required, your code works now. I have copied your code in to new workbook, it works now.
Is it possible to have list of column headers in other worksheet, instead of going to module and add? you amend in your first code. thanks so much for your help.