Extract relevant info dependent upon dates selected via drop down box

[monkeypants]

Hi guys,

Please refer to the attached file.

In the before sheet, I have a list of ID numbers and corresponding date ranges etc.
On the after sheet, dependent by the period date selected in the drop down box in G1 (and period end date in I1), I want to extract only those ID numbers etc where the period start and end dates cover the start and end dates in the before sheet.

I have populated the after sheet with what I want returned when the period range is 1st to 31st March.

Obviously, if G1 was changed to 1/7/15, the returned list would not contain ID number 3.
Dependent upon the amount of rows of extracted data it returns, I also would like the weekly amount column summed after the last row of data returned.

Thanks in anticipation.