Copy Entire Column from Multiple Workbooks through Header Name and Paste Appended Result into Opened

I am looking for a code and i have looked around but could not find anything related. Thought to post a question here.   I have multiple workbooks in a Folder around 8 and there are Similar columns...