copy cell data to another sheet based on month entered

Hello,

on the attached worksheet i'm trying to get the data from "Closed Business" to The "Executive" sheet when the Month, for example "October" is entered into cell J2 on the Executive sheet, (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. I have some similar codes that I have got from here, but am not advanced enough to know how to tweak them to this worksheet.

Thank you for any and all help.