Using multiple criteria to find data in multiple sheets

[RobVanWinkle]

Hi all,
I've searched everywhere, and can't seem to find a solution that works and need some guidance. I have a workbook that has 5 different sheets, all containing similar date (Columns are the same on each sheet). I need to keep these sheets separate.
The user selects their four options (each based on columns in the existing worksheets), and the query pulls the remaining data from the other columns that match that criteria (or maybe better stated, It shows me all the rows that match those four options). Here's an example of what I'm trying to do (where the top table are my options to select, and it pulls the data from the rest of the columns were those 4 options all match). Any ideas?

Option 1	Product
Option 2	State
Option 3	Yes or No
Option 4	Fee or No fee

<tbody>
</tbody>

Who

What

Where

When

Why

<tbody>
</tbody>

 

[RobVanWinkle]

Here is a better example of the table. The data that is shown is pulled from two other worksheets (as described in the question), based on the selections in drop downs for Product, State, Y/N, and Fee/No Fee:

Product	Elephant
State	IN
Y/N	N
Fee/No Fee	Fee
Who	What	Where	When	Why
Smith	Cows	Cabinet	Thursday	Collateral
Walters	Geese	Cabinet	Tuesday	Collateral

<tbody>
</tbody>