Extracting Data from specified Cols in Multiple Workbooks

Hi Folks
Hoping someone can help me through this project- I am 'dummy' personified when it comes to Code-

I currently have 30 individual Workbooks and that number will be increased to 86 over the next couple of months-

All the Workbooks are stored in D:\ and all Headings are identical. The Sheet names which I want to import the data from will all have the same name-

What I am looking to do is import the data (values/text) from the specified Cols but only from those Workbooks that I identify by placing the value '1' in a Col adjacent to the Workbook name all of which will be listed in a separate sheet, and only the Rows where Col CE in the Workbook sheet has the value '1'

I have attached a sample Workbook as I would like it to look for your perusal-

I would need full detail on how to add all the required Workbooks to the Code as they become available-

One question I have right now is, will the workbooks have to be open in order to extract the data? I am hoping not as the Workbooks are all >=40mb minimum and are slow in opening due to links to other files.

Regards
hammer