Multiple Excel files merged into one

Hi, I'm wondering if there's a way to grab multiple excels files and merge them all into one work but have those files each as a different sheet in the work book! Right now the process i have to take is to open up each work book & move/copy each sheet into the main workbook I am using. Please help.