Personally, I find anything too automatic troublesome.
If I make a change to a row and the data gets copied to a different worksheet,
then realize that I made a mistake and change the value back, the row would get
copied over again.
I think I'd do things differently.
(This is just a suggestion. You can ignore it if you want.)
I'd put a date/time stamp in a dedicated column of the input sheet. Then I'd
apply data|Filter|autofilter.
If I needed to see the rows that changed, I could filter to show just the
changes from today (or yesterday or last week).
If I needed to copy this to a different worksheet, I'd do all my data entry,
then apply data|filter and just copy those visible rows to that other sheet (But
I wouldn't separate my data!).
If you want to try this, you may want to look at J.E. McGimpsey's routine:
http://www.mcgimpsey.com/excel/timestamp.html
And if you need code to do the copy|paste, you can record a macro when you do it
manually and then tweak that recorded code.
===
Again, I'd do my best to keep the data in one location. It'll be a pain to have
it in multiple spots.
