In Origin 2025, user can choose <All> import all sheets at once.

Drag and drop Excel file uses <last used> settings. So if you pick <All> to import all sheets and later drag other Excel files, all sheets will be imported as well.

Note: If you pick a specific sheet to import and later drag and drop another Excel file without such sheet name, 1st sheet will be imported.