Perhaps you don't need a macro to do it! Place this formula in Summary!A2 and
copy it to the other columns! Make sure that sheets "Jan06", "Feb06"......
are after each other!

=SUM(Jan06:Feb06!A2)

Regards,
Stefi

€žFreshman€� ezt Ã*rta:

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.