Sheet Reference and Multiple Criteria Lookup Formula?

[lshub]

I've been searching google and through trial/error trying to figure out how to accomplish the following and not having much luck.

A little bit of background on the file I'm trying to create. Each worksheet of the workbook will be used to collect data about specific individuals in a particular city. In the rows of the worksheet, there are yes or no questions. In the columns, there are two identifying pieces of information. The date of conversation is on one row, the specific individual on another row, and then the question answers. I want to create a summary page where a user that has filled out a worksheet tab for a certain city can fill the city (the worksheet number) and then fill a date from that city and populate all of the participant ID's from that date in one column and Yes answers in another column

This is how the data is configured on the worksheet tab

Worksheet Name - 73008 (City Zip Code)

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Date[/TD]
[TD]030617[/TD]
[TD]030617[/TD]
[TD]040617[/TD]
[TD]040617[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Participant ID #[/TD]
[TD]115[/TD]
[TD]237[/TD]
[TD]882[/TD]
[TD]436[/TD]
[/TR]
[TR]
[TD]Question 1[/TD]
[TD][/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]Y[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Question 2[/TD]
[TD][/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[/TR]
</tbody>[/TABLE]

As users collect this data, the goal is to be able to create a quick summary sheet that lists all of the participants for the given city and date and any questions that were answered Y.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]City (Worksheet Name)[/TD]
[TD]73008[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]040617[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Participant 1[/TD]
[TD]882[/TD]
[TD]Question 1[/TD]
[/TR]
[TR]
[TD]Participant 2[/TD]
[TD]436[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The number of ID#'s will be fairly fixed per date. I thought I might be able to create multiple defined ranges and then use indirect/hlookup to pull those unique #'s into the summary and then use that value to search the question answer columns, but that hasn't been working whatsoever.

Any help in the right direction would be greatly appreciated!