If you look at the sheet names in the properties window of the VBA editor,
there *are* instances where Excel seems to get a bit confused. I think it's
something that occurs when reordering sheets, but unfortunately I can't
really remember and I don't know what effect it has on printing, if any.
It's certainly worth searching for on the internet, I would say -
particularly in the Excel groups on http://groups.google.com/

As an experiment, have you tried copying the sheets into a new workbook to
create a replica? Try doing it one sheet at a time and in the order that you
want them to be, and see what happens. If it's something that has to be done
regularly then obviously this isn't a practical solution, but it may give a
clue as to whether we're on the right lines.

Paul C,