Is it possible to have sheets displaying specific parts of a 'main' sheet that also update automatically?

Sorry, I had to repost because apparently my title wasn't specific enough.

basically, I have a project im working on that im using execl for. What I wanna do is make a giant list with Execl and then have multiple sheets displaying specific info from the main list and still have each sheets be able to able to organize/filter the mini list it has.

EXAMPLE:

MAIN LIST

Cake - Vanilla - 2

Cake - Chocolate - 1

Cake - Strawberry - 1

Donut - Vanilla - 1

Donut - Chocolate - 3

Cookie - Chocolate - 2

VANILLA LIST

Donut - Vanilla - 1

Cake - Vanilla - 2

CHOCOLATE LIST

Cake - Chocolate - 1

Cookie - Chocolate - 2

Donut - Chocolate - 3

STRAWBERRY LIST

Cake - Strawberry - 2

kinda like that, but I would also like it if each time i updated the main list, it would automatically update the relevant list.

ex: i add 'macaroon - Strawberry - 1' to the main list, and then it automatically shows up in the Strawberry list above 'Cake - Strawberry - 2'

I've tried to turn the main list into a table and then made another table on separate sheets, use "= main list ! a1" to copy the data , and use the table filter to show the specific info i want on each one, but when I type new things into the main list, it doesn't update automatically as I would like.

Is there any way for what I want to be possible, or am I gonna have to throw in the towel?