vba to email after modifying a single sheet from wkbk as a PDF attachment

I have a work book that the CSRs in my office use to come up with the correct dollar amt to charge a customer i am wanting to take this same wkbook and use it to send the request to the insurance broker via email ...

The report that i want to send is most of the info on the "Endt Request to GA" tab. These request sometimes go to three different brokers (one for each Line of Business) ... the email addresses are in 3 different cells (according to the line of business), in the "Annual Premium Data" tab... NOTE: many clients have the same Broker (GA) for 2 or all 3 of the Lines of Business (LOB s )so will want the script to consolidate if this is the case....

I would like the vba script to "clean up the report" i want to get rid of the the zeros and the extra lines created by them and to drop the "A17 & A33 cells ...

Prefer to send as a pdf document... We do sometimes need to put other email addresses in the CC or Bcc fields. ...

Can this be done? It does seem like quite of bit of coding and I dont have the slightest about VBA ... I am thinking this may need to go to the commercial... If we do that i have a bigger "wish list" ... having to do with USER Forms & screen scraping of a website ...any takers? Also let me take the time to note my appreciation for this forum, i have learned sooo much... thanks for all the help.

Also let me take the time to plug the commercial side of this site. i have had one experience and the guy JACOB H. was GREAT! Did what he said he would and was very responsive to my many request for the database that he created to my specs.

Closed at request of dyoung785 to be reopened in Commercial Services.