Are the tasks and description in column A and B. Does each worksheet have
aditional columns? Are the columns the same in each worksheet? It help to
have examples of the data to get the macro correct the 1st time.

" wrote:

hi guys,

I have an excel spreadsheet that contains multiple worksheets.
each worksheet has a task list (say task ID and task Description).
I would like to have the tasks reported in each worksheet to be also
shown (automatically copied) on a separate worksheet so that it will
include all the tasks shown on the single worksheets.
is this possible ? how should I do this ?

thanks
zz