Check this post to learn how to import all Excel files in a folder, even if they have multiple sheets.
