Add cases opened and closed for each month and specifics about the cases.

I am stuck.
What formula do I use to add how many cases are opened for each month? I want the data to pull form the Active sheet and send to the Data sheet as I plan to make tables and/or graphs with that data. Also what would be the best function for gathering the other data listed in the data sheet?
Thank you very much.