typical select the sheet and move (or copy) to another workbook open in the
same session does not work in Excel 2007.

I get the following error message: "Excel cannot insert the sheets into the
destination workbook, because it contains fewer rows and columns than the
source workbook..." it goes on to recommend a 'copy and paste' approach to
get the data in the new book, which is not efficient.

any thoughts?