Blending unlike joining is not universal for each workbook. You can blend on some sheets and not on others. I see in Sheet 21 you blended but in the other sheets I do not see something being blended. You may want to use that selection as a filter across all sheets in your workbook. In that case I would add in the blend on each sheet and then bring in that one filter you are after onto the filters shelf. Right-click it and then you can choose if you want to apply it across the data source of multiple worksheets. Make sure your blends are all the same or things are not much fun to track down later on.