Gary,

Thanks Gary. The code you gave me works just as I asked. However, my
question was flawed as I don't need to list the name of sheet1. So is
it possible to have the module start with the name of sheet2? Sheet1
is a summary of the other sheets. As a result, I do not need to have
the name in sheet1 anywhere in sheet1. The data in column B will come
from sheet2, column C from sheet3, etc...

Thanks again for your help.

Omni