I need help with work book saving

Dear All
Excel work book contains numerous named work sheets.I want to globally convert these work sheets into individual work book and saved individually
Any help I shall appreciated
..................................................................................................................................................
Lets me explain more about this,I'm using information from accounting system, I copy and paste to excel to form new work book which has numerous sheet,i.e. Sheet1,sheet2,........to sheet20 each one has various information.
Now i need to save each sheet seperately from original work book.For the moment I'm using move and copy to a new work book then I save wherever i want to save
Now the problem is it takes more time and I'm supposed to open so many new work book
So can I get your help,to do this job easily and less time consuming
Thank you
Wahiba

Hi,

Try this link

http://www.rondebruin.nl/copy6.htm

VBA Noob