Need to have data transferred as it is typed onto another wrksht
 

I am needing to have data that is entered onto several worksheets (each day
of the month has a worksheet) onto a TOTAL worksheet.....for example, I need
only the information entered on the worksheet (there may be blank rows in the
report) for Feb 1st to Feb 28 entered onto a Grand Total worksheet. The Grand
Total worksheet is identical in settings & column headings.