Hello,

Recently, I've been trying to link worksheets from other workbooks to a consolidated workbook. I'm still a beginner at VBA, so this was a little difficult.

Instead, I'd like to open up workbooks, copy selected sheets, move to a consolidated workbook and then close that workbook. I have to do this for about 100 workbooks, so I'm not too sure how quickly I can do this.

Is there some way of doing this efficiently.

Thanks