Pivot table filters reset when erasing or replacing data

I created a spreadsheet to track sales data which contains multiple pivot tables.  I intend to save multiple copies of the sheet for individuals to use, then pull all the data into a master workbook....