SUMMARY:
Is there a method (simple?) to copy the 30-40 individual worksheet tabs from 1 Excel workbook to individual workbooks? 1 workbook for each tab in main workbook.

DETAILS:
My main workbook has a pivot table with a Department filter. I then used Pivot Table Tools > Analyze > Options > Show Report Filter Pages to create individual worksheets for each department's data.

Now need to place each department's report into a separate workbook.

Thanks,
Bob