Selecting Data from one table to another between dates

Greg- There might be a way to incorporate this data with a pivot table but it is probably going to change to much of the layout. The attached tables in the sheets are naturally surrounded by other tables and graphs so a pivot table would cause changes to that along with changes to the original list that I don't want to change unless there is no other way. Attached is an updated version of the sheet that I had with some manually typed inputs into the results table in sheet 2.

Thanks
JR