I have a line of VBA code Workbooks.add to add a new book. What I want to accompish is to copy a sheet from another existing book (where the code is located) to the new workbook. Though the new workbook number can change. How can I get it to paste in the new book reguardless of the number its assigned?