One master list to auto update several other lists

Hello!

I’ve been looking all over but haven’t found anything quite like what I need. I’m hoping you all can help.

Let me try to summarize. Ideally I need to have a master sheet with all my data that automatically updates several external sheets with specific data from within the master. They also need to be able to add and delete automatically when the master is updated.

For example I have a table of account numbers, their amounts, rates, related entities, etc on the master sheet. I’ll also need spreadsheets that only shows account information for Entity A, another for Entity B, and so on. Entity A and B may have some of the same account information, but not all.

I know I can reference the master with a formula, but if new accounts are added, I’ll have to manually update each sheet. I’d like to avoid that.

I looked into Power Query, but I don’t need it to combine multiple sheets or manipulate any data. Pivot tables also don’t seem to be working for this.

TIA.