How do i auto create multiple files from 1 with multiple sheets
 

I'd like to automatically take a file with multiple sheets, and "send" each
sheet to its own file for distribution (ex. one file with 10 tabs, separated
into 10 files with one tab). Is there an automatic command or macro to use?
It's easy enough to create the multiple worksheets with the show pages
function from a pivot table... now how do i get them to be their own files
just as easily?

Thanks for any help!
Kathy