TO split worksheets in a single file to multiple files

Hi Dear Friends,

I have attached a spreadsheet file, which has multiple sheets named-Harry, Steve, Thomas etc

I will need a technique where I can split this single file in to multiple files based on the worksheets within the original single master file. So once I have the split, I would like to the files to be named based on the names in the master file

example- Harry.xls, Steve.xls, Thomas.xls

This is just a sample file, I will have a huge number of worksheets (16 nos) in the master file and I occasionally do add and delete worksheets from the master file

Any help will be greatly appreciated

Thanks
Dumbo

HI Leith. Thanks for your reply. I would like to save the new files in to a new sub folder named "Communication".

But if this is a big hassle, then I have no issues saving the new files to the same folder as master file.

Any help please ?