Allow me to copy mutiple worksheets that contain a table
Excel will currently not let you copy more than one worksheet at a time if any of them contain a table. This needs to be allowed.
Kenneth Barber commented
Anonymous, your solution won't work so cleanly if the sheets being copied contain a table and a PivotTable based on that table.
This is how I get around this issue: In the same original workbook, you could convert an Excel table back to a regular range of cells then copy the multiple worksheets and in the target workbook, convert it back to table.