macro to move data from one sheet to another by month

Hello, on the attached worksheet i'm trying to get the data from "Closed Business" to The "Executive" Sheet by month, when the Month is entered into cell J2, (I entered the first row in as an example) This would then save as "Closed Business for Distribution - October, 2016" , or whatever month is entered in J2, in a file to my desktop.

Also this would be going to upper management so if you have any ideas on a way to make it more appealing to look at that would be great also. This is not important, was just looking for ideas if you have any.

Thank you for any and all help.