Combining multiple workbooks into a single workbook with each on separate sheet

Hello,

New to this site and tried not to post but can not find the exact solution. I am trying to combine multiple workbooks into a single workbook but with each workbook being on a new sheet. I used the code from the post at:
http://www.excelforum.com/excel-prog...-workbook.html
This works except it puts all the data on the first sheet. I would like to have each workbook on a separate sheet. I use these spreadsheets to track training for my unit so it is always changing. Thanks in advance for the help.

William Parker