Generate reports based on supplier by outputting to an excel file with several sheets

[MWarner]

Hello,

I need to generate a weekly report based on supplier using a template excel file that contains formulas. 

The excel file I need to output to has several sheets and I need to output into two of the sheets to populate the data for the formulas on the other sheets.

I would like to output a new file every week, using the name of the suppliers and week in the filename. For example: file-supplier-date.xlsx 

Then I would like to email this report to the supplier after it has been generated.

How could I go about doing this?

Thank you very much.