Set Explicit filter for a tabsheet

[#1]

I want to show the data in multiple sheet for different category and I want each tab to be fixed for that category. Just wonder how it is possible. Need help.

[ramoncova06]

you can do this by using set analysis

A Primer on Set Analysis

Set Analysis: syntaxes, examples