Membership database filtered and placed in new sheets using macro

Firstly, thanks very much in advance for your help!

I have a database of membership (500) I need to be able to easily filter a downloaded csv by area then have each filtered area (13 of them) placed into a new sheet.

I can do this manually for one area using the filter and ctrl C/V but I would like to have a macro, or something automated, that I can click and does it automatically for all areas.

Also it would be cool to be able to quickly tell totals for each type of membership (5 types). How can I ask excel to count each membership and put a summary in a sheet?

Thank you 

kind for your help, Lee-Anne