[excel 2011 mac] save two sheets as PDF and e-mail one of them

Hi everyone,

I have been on the past few days browsing the forums and the web to solve this issue.

Twice a week I send out a report, one report goes specifically to one client (15 people in one company), the other report goes to 150 clients – which is sent later via MailChimp.

I use Mac Mail and Excel 2011.

I have tried many codes found on the web, some would save sheet one, but not sheet two, some would send the e-mail, but not save the pdf...

On the attached Excel, I have a few spreadsheets, the one I manually edit is the Price_Report_Blaser, Price_Report copies the data.
Price_Report_Blaser is the one that should be sent as e-mail, and Price_report should always be named "Price_Report" & "_" & Format$(Date, "yymmdd") so it is Price_Report_150702. The spreadsheets are on a dropbox folder, so the PDF's should be saved on the same directory, reminding I am on Mac.

Can anyone help me out with this?