I have a workbook (well actually a LOT of workbooks) with sheet names that correspond to a day (i.e. 09-05-06). There are 7 sheets per workbook, one for every day of the week. I'm trying to design a Macro to count the number of Yes and No's in the different columns on all seven of the sheets.

What I'd like to do is somehow determine the names of all the sheets on the spread sheet so I could plug them into an array. Any idea how to do this?