@Winon: I just followed the code in the file attached to Post #1. If geniusufo007 has a problem with the sheet already existing, I can easily modify the macro I suggested to take care of the problem. I believe that a Worksheet_Change event is probably the most efficient way to handle the original request.
@geniusufo007: Please let me know how it works out and if there is a possibilty that the sheet already exists.