Yes but I need the company code filter to apply to all the worksheets. When I select the worksheet it then uses the top 5 field I selected for one sheet for all of them. I need to show a different top 5 for the bottom graphs
So if I am understanding, you need the Top 5 filter at the top to apply to all worksheets, the issue is when you select a worksheet whatever filters are applied on that worksheet are then applied to the others. For the worksheets that you are selecting, do you have the "Don't use as filter" option selected so that when you select an item it does not pass the filters on towards the other sheets?