Use Import Records to Import from your Excel file. There's an option that pops up to allow you to select the worksheet from which to import. Do this once for each worksheet and you'll have all your data imported. You can use the new table option to create each table as part of the import if you have not already defined a table for each worksheet.
Note: Only data is imported. Formulas in Excel cells cannot be imported.