Hello,

I have a macro that I LOVE that takes multiple workbooks (single tab) and combines them into one workbook w/ multiple tabs. I'm looking for the reverse of that. I very frequently get workbooks with multiple tabs that I want to separate, but the move/copy function gets a little monotonous after awhile. I'd ideally like a folder where I can add said multi-tab'd workbook and then open my macro'd excel file and poof! Multiple workbooks would cascade across my screen like a flowing river. Anyone know how that might work?

I'm using Excel 2010.

Thanks,
Aaron