Excel Macro Development

I require a template report I have created to be populated automatically each month from a pivot table, which I also create. I currently populate the data into a report manually which is very time consuming as I have up to 60 Vendors. - currently I create a dataset at the end of each month that includes the sales for all vendors off our e-commerce website - I then translate this data into a pivot table - then I manually cut & paste each Vendor and their relevant sales summary data into a template report - that report is then saved to PDF - this process is repeated for each Vendor (1-60 vendors p/m) DEVELOPMENT REQUIREMENTS I require an Excel macro to be developed to automate the above process. To automate the data populated into my report template from a 'pivot table. I see the development to include: a) read the pivot table data and loop through each Vendor (max 60 vendors) and their relevant summary sales data b) for each vendor automate the copy and paste of the data into the template report (supplied) c) then save the report to PDF file format and move onto the next vendor I have attached a file which includes several worksheets... The "Report" worksheet must be populated by data from the "Pivot" worksheet OR "Vendor Data" worksheet (either is fine). *NOTE - if the pivot table or Vendor data worksheets need to be slightly altered in layout to make the macro development work, that is ok. The REPORT template must remain unchanged in format/layout. Development must be compatible with MAC and MS Excel 2011 for Mac.