How to combine multiple worksheets in multiple workbooks into one workbook

My question is about combining multiple worksheets in multiple workbooks into one workbook via VBA. Recently arlu1202 (http://www.excelforum.com/excel-gene...html?p=2974259) provides answer to the situation where one needs to combine multiple worksheets of one workbook into one worksheet, which is very helpful. I am wondering by any chance somebody would help me to handle a little bit complicated situation as indicated above.

Thanks in advance.
T.