Yes... I can open  them all...

I'm thinking

Dim cBook as collection


Set cBook = new collection

'I put into the collection  after the sheets  have there data added and
after saved with there proper naming conventions
cBook.add oBook.worksheets 'would I book  just the obook or put each
sheet in the collection


'here's wher my mind goes to spaggetti
For I = 1 to cbook.count

'the workbook (I have 39 or 40)

'then the sheet1
'need sheet  count in here right... I know its 12

'next workbook

****once I have gone thru all 40... How do I get back  to book 1
and to the 2nd sheet...

Next i