One way to do this is by using actions. The following Kb provides instructions on how to do this:
Hope this helps!
Thanks Tracy. I has looked at the example. The difference here is that in my worksheet, I am not showing "Region/Market" on the workbook as in your example. The filter from the different data source is a behind the scenes filter.
I guess I could just do a join instead of using data blending.