Macro To Add New Worksheet

I notice a few others have replied since I started looking at this. Anyway....

I think you are saying that normally A30 contains Totals, but sometimes it is cell A31 or A32 etc. If I can assume that ONE cell in column A at or below A30, then the following code will find the cell for you.

Range("A29").Select
    Do While Selection.Value <> "Totals"
       Selection.Offset(1, 0).Select
    Loop
    myrow = Selection.Rows
    mycell = "e" & myrow
    Sheets(NoOfSheets + 1).Range("E2").Value = mycell.Value

Matt