Google Sheets Tab Split Automation

I maintain more than 100 inventory-tracking Google Sheets and need a repeatable way to break selected sheets into three separate tabs automatically. Each split must focus on Inventory data and group rows... (Budget: $10 - $30 CAD, Jobs: Automation, Data Processing, Excel, Google Sheets, PHP, Scripting, Software Architecture, Visual Basic)