Hi
this would be only possible using vBA event procedures (e.g. worksheet
change event handlers). Do you want to go this way?

--
Regards
Frank Kabel
Frankfurt, Germany

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??