Thank you in advance for your help. I created a pivot table of employee credit card charges and created a separate sheet for each employee through the "show report filter pages" function. Is there a way to separate these sheets into individual files so I can email them to the employee?