Need VBA to create new Workbook and name it based on cell value in original file

The dates are posing a problem. In the Summary_Cash_Flow sheet, the months in C2 and D2 are the same, both October. In all the other sheets, the months in C2 and D2 are consecutive months. This presents a problem with adding the values from whichever sheet has the earliest date in C2. In this case, that is sheet Morristown_CF where C2 has the month of October. Since both C2 and D2 in the Summary_Cash_Flow sheet have October, in which column, C or D would you add the values of column C from the Morristown_CF sheet? Does that make sense?

You may want to note that the months in row 3 of the _CF sheets don't match the dates in row 2, although this wouldn't affect what you're trying to do.