I need help with building a macro to pull data from over a 100 worksheets.
I have a questionnaire that I send out and now I need to pull the data from the worksheets. Every work sheet is the same.

To give you an example to what I need to pull, I have a question: Is your facility a standalone or a system?
In cell C10 and E10 there would be a box for them to put an X. I need to know how many X's or anything typed in that cell from all of the worksheets.

To help, I have all of the worksheets saved in one folder.

Thank you for your help in advance