I have a workbook with a pivot table and multiple spreadsheets. How do I email each spreadsheet in the workbook to different people? I only want that one person to be able to view just the spreadsheet I am sending them not the entire workbook or other spreadsheets. I have been saving the workbook as xxxx report and then deleting the other data and worksheets that do not pertain to that person and then emailing that workbook, very time consuming considering I have 20 people to send a report to. Any suggestions?