2 Related Questions: Finding Value Recalling Other values based on that

I have 2 questions that deal with the similar issues.

Question 1:

Please Login or Register  to view this content.

I want to know can I output into another sheet the values based on the month. So I would have a drop down window with the months, and if I selected May, all the data from Row1 to Row 4 would show up
If I selected June all the data from Row 5 to Row 7 would show up

Question Two:

If I have the Same Table, I want to find out the Sum of the Deals in the months, so I want to create a table that shows the months, and then the SUM of the Deal Size Column

Thanks So much, I'm at a loss on how to do this