Darren

You can copy a single worksheet to a new workbook like this.
[vba]
Worksheets("Sales").Copy
[/vba]