hi,
I have 15 sheets with same format . One of themis a master sheet whcich
is adding infomration from the cells and rows form the other sheets in
the same rows and cell.
Suppose Master sheet adds all the records from Sheet from cells B1 of
SheetA2 to SheetA14 in cell B1 of Master sheet.

The problem is the number of sheets is dynamic. everytime there is new
data ,a new sheet is inserted like A15 , A16 and so on .
Is there a way for the master sheet to recognize the new sheet and add
the same ( row col ) data in itself.

I would really appreciate your help.

Thanks