Can you send me the actual final code you used to do this? I cant seem to get
it to work.

thanks!

"Nadia" wrote:

I would like to enter data into lists on 3 different sheets and I would like
that data to automatically collate on a summary sheet (i.e. as soon as I hit
enter after typing the data in one of the 3 sheets it should appear on the
summary sheet on the next available row).
Can this be done??