Filter data into multiple subtables

[rishid]

Hi,

I have a table with data like:
Name | Description | type
blah | blah blah | 1
blah | blah blah | 1
blah | blah blah | 1
blah | blah blah | 2
blah | blah blah | 3
blah | blah blah | 3

I am trying to extract this data and make tables for each type example:
Name | type
blah | 1
blah | 1
blah | 1

Name | type
blah | 2

What could I use for something like this? It doesn't have to be automatic, as the number of types are limited to only 5 or 6 options. I just want it to update the filter automatically as in if I had another row to the main table it will add it automatically to the corresponding type-table.

Thanks for any help or suggestions.

Regards,
RishiD