>I'd like to be able to take the first worksheet from multiple excel files and copy them all into a new workbook. So, say we had 3 xls files and each had data only on the first worksheet. I'd like to grab the first worksheet out of each of those files and add it to a brand new workbook that get's created through code. I would end up with a workbook that contains 3 worksheets of data. Thanks.
You can open more than one workbooks and use Copy to copy from one to another.
Cetin