extract rows from sheet based on multiple criteria

First of all, hello everybody, i'm new.
Second thing, please excuse my english i'm french. Despite of this, I hope i will be understood

I'm a total newbie in Excel, and i want to make something very easy in theory, but quite tricky in excel...

I have a raw data sheet.
I would like to extract rows from this sheet to others sheet, based on multiple criteria. I've made it via advanced filters, but i would like to automatically do this, because i have a lot of sheets and a lot of criteria... and i have to update this excel very often

I have joined the example file.
The sheets representing differents mix of criteria are fixed. But depending on the criteria, the number of raws to extract are not the same. and i want to list only the rows which are ok with the criteria.
The raw data sheet will be the one updated, and i would like it updates all the sheets, changing the values and the dates.

So i'm ok with advanced filters, but very long to operate due to a lot of sheets and criteria.

I hope i was clear enough, and someone will have an idea to make it

Raw data sheet
OBJECT1 OBJECT2 OBJECT3 size date
car wheel red 3 9/1/2012
car wheel blue 5 9/1/2012
bus door red 2 9/1/2012
bus door blue 7 9/1/2012
car door red 5 9/1/2012
car door blue 9 9/1/2012
car wheel red 2 9/2/2012
car wheel blue 4 9/2/2012
bus door red 3 9/2/2012
bus door blue 3 9/2/2012
car door red 7 9/2/2012
car door blue 8 9/2/2012

data sheet on car+wheel+red criteria
OBJECT1 OBJECT2 OBJECT3
car wheel red

OBJECT1 OBJECT2 OBJECT3 size date
car wheel red 3 9/1/2012
car wheel red 2 9/2/2012

data sheet on car+door+red criteria
OBJECT1 OBJECT2 OBJECT3
car door red

OBJECT1 OBJECT2 OBJECT3 size date
car door red 5 9/1/2012
car door red 7 9/2/2012

data sheet on bus+door+red criteria
OBJECT1 OBJECT2 OBJECT3
bus door red

OBJECT1 OBJECT2 OBJECT3 size date
bus door red 2 9/1/2012
bus door red 3 9/2/2012


Regards.
Fred

Hello,

first, thank you Marcol for your answer ! This is why i know i'm a total newbie in excel, i don't even understand - yet i hope - your formula !! but it will come.
But in fact, this was only a part of my problem, because in fact i have to make graphs of each "combination" of criteria. this is why i putit in different sheets and moreover i have to make a synthesis on the first page with average on all the values of a combination.. i'm not sure i'm clear because it's quite tricky to explain.

The synthesis would show the average of the month (different from each sheet showing the values day by day with a graph).
And due to the fact that the criteria combination won't produce the same number of rows i could not manage to make a proper graph with all the rows... or without the empty point.
Hope i was clear... but i go back to try to understand your solution, and see if i can manage to adapt it...

Fred

Hello,

first of all thank you for your answer again, and sorry for the late answer of mine.
Ok i did not really managed to understand your solution, but managed to used it as if in my environment, just changing the ranges.. So again thank you, it has avoided me a lot of work and headache ... excel is definitely not my par, but i realised you can do powerfull things whne you are a master of it !

Fred