Find and Return All Values for Selected Date

Greetings all.

I'm currently in the progress of creating a spreadsheet but stuck and need some help please.

I need to be able to find and return all values for the selected month and handle errors if the formula don't return any values.
To sanity check what is returned, i will need a formual to count all values for the selected month.

Example:

Sheet 1
Contains all the data
A1: Start Date
B1: End Date
C1: Number of days
D1: Total

Sheet 2
Summarise data
A1 - Drop Down list of Months (Validation List)
Formatted: mmmm yy

B2 - {formula to count all values for the selected Month}
A3: Start Date
B3: End Date
C3: Number of days
D3: Total


A4 - D4: Would contain a formula to return all the values for the Selected Date (Decemeber 12) from A1


If i've missed anything let me know.

Thanks in advance.

Stu(pid)