Data workbook with linked subset tabs

[duranimal86]

I am trying to determine the best way to setup my workbook and i keep going back and forth between pivot tables, VBA, and Power Query and can't figure out what is right. I have a data file with a large number of transactions and i want to have separate tabs display a subset of those transactions based on values in 1 or 2 of the columns for distribution to different parties. I also would like to be able to easily update the data file/tab with new data and be able to refresh all of the tabs with the latest data.

For example, based on the data below i would have 2 scenarios:
1. I would want to have 3 tabs (100, 200, and 300) that pulled all transactions with that corresponding Cost Center (column 3)
2. I would want a tab for Cost Center 400 and Account 6000 and a separate tab for Cost Center 500 and Account 6000.

[TABLE="width: 400"]
<tbody>[TR]
[TD]Period[/TD]
[TD]Date[/TD]
[TD]Cost Center[/TD]
[TD]Account[/TD]
[TD]Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]100[/TD]
[TD]2400[/TD]
[TD]2400 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]200[/TD]
[TD]1100[/TD]
[TD]1100 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]300[/TD]
[TD]1100[/TD]
[TD]1100 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]300[/TD]
[TD]5000[/TD]
[TD]5000 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]100[/TD]
[TD]2400[/TD]
[TD]2400 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]200[/TD]
[TD]1100[/TD]
[TD]1100 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]200[/TD]
[TD]1100[/TD]
[TD]1100 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/8/19[/TD]
[TD]400[/TD]
[TD]6000[/TD]
[TD]6000 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/10/19[/TD]
[TD]500[/TD]
[TD]6000[/TD]
[TD]6000 Account Description[/TD]
[/TR]
[TR]
[TD]01-19[/TD]
[TD]1/10/19[/TD]
[TD]400[/TD]
[TD]6000[/TD]
[TD]6000 Account Description[/TD]
[/TR]
</tbody>[/TABLE]

What would be the best way to set this up to automatically pull the data across all tabs and be easiest to refresh with new data?