Individual department in a pivot table emailed to managers

[crashsf]

I have a pivot table with employee data for about 60 departments (cost centers) each with it's own manager. I am filtering the data by department. Each department's employee data from the pivot table needs to go on its own worksheet/workbook. I then need to email each department's data to it's manager. What is the best way to automate creating the individual worksheet/workbooks and then emailing it to each manager? Thank you.