Select and Copy By Date Range

Hello,

I am attempting to select a row if the date field value is within a date range.

I would like to be able to click a button, have a pop-up, be asked to insert a start date and an end date. For example 2014-07-01 and 2014-07-21
I would then like the macro to copy rows if the date value is within that range to the next available row onto a new worksheet. Could someone show me some code or point me to some documentation?

Thank you kindly,

MG

Attached is the Excel file and this is the report I'm trying to create with this macro. I would prefer not to use Pivot Tables if and at all possible. Thanks to anyone that is able to assist.