I would like to know if a formula of some kind can recognize, for example red
text somewhere in a work sheet and copy the value to another worksheet.

We use Excel for our timesheets. I would like to keep track of my sick time
and vacations by putting them in red when I take them and compile them on a
seperate worksheet.