How to create Smart Categories in a new tab in Apple Numbers

Hello Everyone!

I'm currently handling large amounts of data in the Numbers App on my Apple Macbook Pro.

The issue I'm facing is that I can only create Smart Categories based on the data provided in the Tab itself, and not in another tab.

Compare this to Microsoft Excel, in which a similar function called "Pivot Tables" could be used to use the data in one tab, and create categories and charts in another tab.

The only reason I want to do this is so that if I update any information in my "Master Data" in any tab, then it should automatically update my categories, charts, etc in the other tabs.

In Apple Numbers, in order to update the "Master Data" again, you have to untik the Categories option, update the changes in your "Master Data", and then re-apply Categories again, which is a tedious process, and you often have to re-create the categories again and their corresponding charts.

Please suggest if there's a way to achieve the above?

Thanks everyone!