pivot table reports and drop down menus

Hello. I have an excel spreadsheet that I use to create pivot table reports. Once the reports are refreshed they are copied to a new workbook to send to each individual salesperson to evaluate. The problem I am having is the drop down menus that are originally in the reports before copying to a new work book are lost once they are moved to a new workbook. I understand that this is because the cell reference is in the original workbook but is there a way to have these drop downs stay in the work sheet?

Not a pivot table filter. The column I am referring to contains a status of an estimate which are won, open or lost in the main database. On the report it is obviously whatever has been selected and the ideal situation is when the new file is created and sent to the sales person the will have the same three selections to pick from a drop down menu vs having to type it in. I'm thinking it cant be done since it is a pivot table report but I am new to pivot tables.