Huge workbook, lots of tabs & macros--should I use something other than Excel?

I work in purchasing for a large company and I have been using an Excel based tool to manage order and logistics data for years. I started writing macros to help with my tasks and now the workbook has nearly 20 tabs and 30-odd macros...things are getting way too beefy and I am wondering if I need to use something else to manage it. The general layout is:

• 2 tabs with order data (one at PO level, one at line item level) using conditional formatting, XLOOKUP columns that reference other related data on other tabs, and macros for importing/processing new data.
• 2 tabs to track receiving--one is 2 years of history and the other is a working sheet w/macros to pull receiving for a given number of days, look at the line items against one of the first 2 tabs, and mark lines that are not full order qty (among other things). Also has a macro that 'steps' through each unique PO# in receiving record and filters the first 2 tabs + receiving history tab for that PO# so I can enter things into purchasing system more efficiently.
• Several tabs for reference data (logistics reports, truck schedules, etc.) which are either referenced manually as needed or actually feed into an XLOOKUP on the first tab.
• 2 tabs with a macro to pull certain PO data based on several parameters, which I manually review and then use another macro to automatically generate emails to vendors.

An AI told me I could use Sharepoint and Power BI to recreate the tool to be web-based and able to handle the volume of data I am working with, but I don't trust AIs lol.

Anyone have recommendations of programs or strategies? I have no help from my company so I am doing this on my own to help myself.