It's a bit hard to give any advice when we don't know what goes in each of the seven worksheets, what the relationships are between them and where the data in Word might go or how it is to be formatted there.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]