Using Split an Excel Workbook by Worksheet
Select a workbook to export each worksheet as a separate XLSX file in a ZIP.
Check the result
Review cross-sheet references in each workbook. The export separates worksheet data rather than preserving linked sheets.