pivot table help or other

Tracy-

I have two ideas for you:

1. I think you could benefit from using custom views.  This will allow you to have only one worksheet and when you select a view it will filter on the specific persons data....

See here for reference: https://www.howtogeek.com/257207/how-to-use-custom-views-in-excel-to-save-your-workbook-settings/

2.  Create a table of data.  Then using data connections to show custom filters.  Here are some instructions and a sample file for reference (see attached):

1. Make your data a table (Ctrl + T)

2. Create the additional worksheets for your different sort views

3. Go to an additional worksheet

4.  Data Tab > Get External Data Group > Existing Connections > Tables tab > select your table.

5. Now filter the table the way you would like it

6. Repeat for additional views

7. Add Data to the original source table

8. Go to Data Tab > Refresh All

9.  Now you can see that all of your tables were refreshed and the sorts you set up stay in place

Here is another thread that is similar for additional reference on this method:

https://techcommunity.microsoft.com/t5/Excel/Adding-information-to-different-sheets/td-p/194438