Report Table based on Month

[Boehmer]

I am trying to work out a solution to this problem...

I have a master data sheet of sobriety dates

Sobriety Date	Name	100 days	500 days	750 days
02/06/14	Sue Morgan	05/16/14	06/20/15	02/25/16
03/23/15	John Smith	06/30/15	08/03/16	04/07/17
06/19/13	Dave Lee	09/26/13	10/24/14	07/15/15

<tbody>
</tbody>

The columns continue out to calculate the days on a 250 day interval

I want to be able to create a report table. In this table I want to be able to enter June or 6 and return all of the events that occur in June of current year.

Month	June
Name	Date	Event
John Smith	06/30/15	100 days
Sue Morgan	06/20/15	500 days
Dave Lee	06/19/15	2 years

<tbody>
</tbody>

I have gotten as far as knowing I would need something like =indirect("('"&B1&"')!active(range)") at least I think.

But I have over 800+ and growing in the active sheet in both directions new members and events.