If you want to Import from different sheets, then there are two things to consider. Are the sheets have same structure? If so, then do you want to Import them to the same FileMaker table? If either of the two is not true, then you have quite different imports.
If you set up separate script steps ( they can be in the same "script", but different Import "steps" ), they you'd set up each needed, and save the script. It will then Import as you've set it up.
So, yes, what you want can be done, but we'd need to know more. [ I am not very good at explaining this, as I am not so good with words. Nor, apparently, at being able to find my own files. I have one somewhere doing something like this, but they are hiding :-| ]
There's a part of the set up for this script step where you can specify the worksheet or a named range.
Phil, I'm sorry, but I don't see your script.
I didn't show a script. I just mentioned a key detail of Import Records when you specify importing from an Excel file. This dialog automatically appears when your spreadsheet file contains more than one worksheet.