Hi Dault and welcome to the forum,

Excel 2016 has a newer tool called Get & Transform (old name of Power Query) that could pull in all the files in a folder and extract what I think you want. It is much easier than using VBA and you may already have it on your version. Here are a few articles explaining it.

http://excelunplugged.com/2015/02/10...n-power-query/
http://www.dutchdatadude.com/combini...ery-for-excel/