This probably is possible but I don't think it's going to be straightforward.
The main problem I see is that you are basing things on colours.
Couldn't the users make an entry somewhere on the worksheet?
Then you could simply use queries to do the update/append.
Otherwise you'll need to search the worksheet for the colours.