In the "Format/Preview" tab of the Excel dataset, you can select the sheets (after clicking at least a first time on preview).
Note that this mandates that the sheets have the same columns. If they don't, you'll need to create several datasets, each one targeting a specific sheet