Importing a single sheet from another Excel file with or without table formatting

Fluff13, you are awesome! Simple fix and works great! Now this is almost entirely idiot proof for my supervisor who has no idea on how to do any of this. Thank you!