How to sort rows in Excel into different sheets using a filter

Hello!

I am new to this forum and I suspect I shall be asking a lot of questions. I have a basic understanding of Excel but have learnt a lot over the last few weeks trying to set up a Master Price List that is synced with SharePoint so that people will be able to view it online and sync it to their costing sheets.

I have had trouble syncing the MPL to SharePoint Online because of Sharepoint's "resource throttling." To go around this I need to get the lists down to 5000 rows or less for SharePoint to sync data correctly. I have tried setting up a macro using the advanced filter to sort my 15000 entries alphabetically and move them into separate sheets but I have found this is way too heavy and doesn't update the sub-sheets when the main price is altered. There must be a way of using a filter that will automatically move data into the various sheets without the use of a heavy macro, but I understand if one is necessary to do so.

I'm sorry if I posted this n the wrong place on the forum!

Cheers and thanks in advance!

Luke