Pivot Table copy to other sheets

[thekgbjr]

I am creating about 50 invoices for a home health agency all on one workbook so there are 50 sheets, on each page of the invoice I would like to create a pivot table for that individual sheet. Is there a way to copy that sheet and make 49 additional copies that will automatically know to pull pivot table info from it's specific invoice, ie sheet1 copy to sheet2 and the pivot table on sheet2 knows to compile the data from sheet2 and not sheet1....is that making any sense whatsoever?

 

[jason1911]

Our home health care consultants will help you start a home health care business.