Separating multiple worksheets into separate spreadsheets

[jonandabby]

I have one spreadsheet of data with multiple (15 or so) pivot tables running off it, each in its own separately labeled tab on the spreadsheet. Is there any macro that would move each individual tab to its OWN new spreadsheet? I have been manually moving each one to a new workbook by right clicking, but it takes forever, and I have to do it all the time.

I use Excel 2010

 

[RJPotts]

http://www.mrexcel.com/forum/excel-...-into-new-file-each-worksheet.html#post351895

Best regards
Richard