将数据透视表外的单元格与其中的单元格相关联 - excel

I'm currently creating a Pivot table in excel with several filters which read in rows. What I need to do is associate a cell that sits outside of the pivot table, with the row of content within the pivot table. So that whenever a filter is applied within the pivot table the content outside it behaves in the same way. I don't want the values/text within the cells to change - just to follow the behaviour of the filtered content in the table. I've tried to add this 'outside' info to the pivot table but it just makes it over complicated. Please can anyone help? Is this even possible?I'm currently creating a Pivot table in excel w