Combining sheets from multiple workbooks into master

I spent 2 days on the attached solution only to be back to this thread to find it SOLVED. I m still attaching it as an alternative solution. I hope the forum rules allow that. The solution assumes that all the files including the master are in one folder. Opening the master workbook fills the list automatically and summarizes the counts.