Copying a worksheet into a workbook object variable

Copying a worksheet into a workbook object variable References I have some code where wb is an existing multi-worksheet workbook. If I copy one of the sheets \"Overview\" a new workbook is created - so why does the following error saying \"object required\"?: Dim wbCopy As Excel.Workbook Set wbCopy = wb.Sheets(\"Overview\").Copy