I have several excel documents that all contain one sheet. i am trying to get them all to open up in one workbook that contains all the sheets. What i am doing right now i opening them all up in excel, then reducing their size and dragging all the sheets into one workbook.

Is there an option for this or maybe some code that could help?