Hi Freshman
You don't need a macro to do this.
If, for example, you want to add the data in A1 of each sheet totalled in
the Summary sheet, simply go to the Summary Sheet and click in A1.
Now type = and then click on the A1 cells in each sheet

It might look like this
=SUM(Jan06!A1+Feb06!A1..............)

From then each time you change data in the sheet cells the summary sheet
will change as well

HTH
Michael M

"Freshman" wrote:

Dear all,

I've a workbook with several worksheets, namely "Jan06", "Feb06"......and
"Summary". This Summary worksheet consolidates all data from columns A, B & E
of all other worksheets in the same workbook(they are identical). Every time
when I filled in all records for that month, I've to copy the data from
columns A, B & E to the "Summary" worksheet for further analysis purpose. Is
there a macro which can copy those required data from any of the worksheets
automatically to the first blank row in the "Summary" worksheet? If yes,
please write me that macro.

Thanks in advance.

Best regards.