Hi NikkiT and welcome to the forum,

It sounds like you need a Table instead of a Pivot Table. Using a Table Auto Filter on a single sheet might do what you want. Although, I believe you are really asking for using an Advanced Filter on your data and putting subsets of it on different sheets. Time to learn about Advanced Filters? https://support.microsoft.com/en-us/...8-3f16abdff32b
or https://www.bing.com/videos/search?q...tail&FORM=VIRE