Kim,

You should consider using Access or any other database program.

HTH,
Bernie
MS Excel MVP

Thanks Bernie, BUT, the reason for so many sheets is that there is a lot
of
data and it won't fit on one sheet.