I need to have data entered on different sheets automatically add itself to
the next available row of a summary sheet (I have some code that will enter
the data on another sheet but will not update if original data is edited!! I
can live with this but would be awesome if this were possible!!)

AND

if it is possible to have the new row in the summary sheet shaded based on a
condition, e.g., if cell=name, shade row blue; if cell=name2, shade row
green, etc.
Is this beyond XL ??
Any thoughts would be very much appreciated.
cheers,
Nadia