I have a workbook with many sheets one of the sheets is a Pivot Table. I would like to give the user the option to create a new sheet with the pivot table sheet and the sheet that contains its source data only.

This would allow them to continue to work without the large workbook needing to be open. This code will be run from the pivot table sheet.

I would appreciate any assistance with this code.

Thank you.