In VBA, you can copy sheets using the Copy method. For instance, to place a copy of the first worksheet at the end of the workbook, you can use a statement like this:
You can also copy sheets to different workbooks. This example copies a worksheet from Book1 and puts the copy into Book2:
The Copy method has two arguments, Before and After, which identify the location of the new sheet. The most you can specify is one, but you can also specify none, like in this example
By omitting both arguments, Excel will create a new workbook that contains the copied sheet. Did you ever want to send someone a spreadsheet, but didn’t want them to see everthing in it? This is a good way to isolate information into another workbook.