Ron de Bruin's EasyFilter add-in probably does all that
http://www.rondebruin.nl/easyfilter.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"T-Diego" wrote in message
...
Can cells be selected from a series of spread sheets by only the cell's
fill
color so that all such entries can then be transferred to a single new
sheet?