Aussiebear - I decided to clean up the code before sharing it and the one HUGE change I made was to have the new sheets appear after the existing sheets. Anyway, this seems to have addressed the problem - not sure why, but the code appears to be working. Thanks.
A did another test and it didn't work, so I was going to upload the code. But some more digging showed that the error was someplace completed unrelated because an array, which I though was being initialized in Workbook_Open, wasn't getting initialized. Anyway, problem resolved.
