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?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Option 1[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]Option 2[/TD]
[TD]State[/TD]
[/TR]
[TR]
[TD]Option 3[/TD]
[TD]Yes or No[/TD]
[/TR]
[TR]
[TD]Option 4[/TD]
[TD]Fee or No fee[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Who[/TD]
[TD]What[/TD]
[TD]Where[/TD]
[TD]When[/TD]
[TD]Why[/TD]
[/TR]
</tbody>[/TABLE]

 

[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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product
[/TD]
[TD]Elephant
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]State
[/TD]
[TD]IN
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y/N
[/TD]
[TD]N
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fee/No Fee
[/TD]
[TD]Fee
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Who
[/TD]
[TD]What
[/TD]
[TD]Where
[/TD]
[TD]When
[/TD]
[TD]Why
[/TD]
[/TR]
[TR]
[TD]Smith
[/TD]
[TD]Cows
[/TD]
[TD]Cabinet
[/TD]
[TD]Thursday
[/TD]
[TD]Collateral
[/TD]
[/TR]
[TR]
[TD]Walters
[/TD]
[TD]Geese
[/TD]
[TD]Cabinet
[/TD]
[TD]Tuesday
[/TD]
[TD]Collateral
[/TD]
[/TR]
</tbody>[/TABLE]