Try the Add Method under the Worksheets Collection in
Help. One word of warning, I believe Excel has a limit on
the number of worksheets that can be placed into a
workbook. One of the more experinced people in this forum
can tell you what that limit is. Just something to take
into account.
-----Original Message-----
Hi

I have a workbook with about 200 worksheets
The worksheets are created with a vba code and their names
are based on the values of cells in columns A and B of
the source worksheet
Data in the source worksheet are grouped, with empty rows
between the groups
I am trying to find a way to add a worksheet in the same
order as new data
is entered in the source worksheet

Thanks for your help

.