Merge one sheet from several workbooks in subfolders excluding one subfolder

Hi guys,

I'm very new to the VBA scene so excuse me if this macro is in fact not unique. However in my defense I have searched for days and not found it to be in existence.

What I essential want to do is to create a Macro that will merge all my excel files in a number of different sub-folders into one excel workbook. All the info I need is located in the root folder which houses the sub-folders so all I need is to be able to collect the specific worksheet I want from each excel workbook in the sub-folders and merge them all into one root workbook.

Plus I want to exclude a specific sub-folder so no excel files are collected from it.

So in summary, I have over 200 sub-folders in the root folder and I want to extract just one sheet from each workbook in their respective sub-folders excluding one sub-folder and compile that specific sheet from all sub-folders into a single root workbook. Make sense?? Thanks a lot!!

NOTE: I cannot move the sub-folder from the root-folder which is why I need the macro to ignore it completely.
NOTE: The formatting and naming convention of the sheets in the excluded sub-folders workbooks are the same as the other workbooks in the other sub-folders so I cannot just change the sheet names.