They are named... I looked in the VBE and they are referenced by Sheet1,
but not an order... I have sheet 12, sheet 9, sheet 7 and so on...
Obviously the easiest is to open each workbook 12 times and print the
first sheet I need, the 2nd, 3rd and so on...
I was thinking I could put them in a collection, have them all open and
then iterate thru the collection one sheet at a time... It doesn't seem
logical that when I reference the workbook from the collection that the
program would now it's a spreadsheet... Plus I can't think of a good way
to programmatically say here is book 1 print the first page, now go to
book 2 and print the first page... Then go back to book 1 and print page
2...