Copy whole worksheet with openpyxl
Solution 1:
Version 2.4 will allow you to do this: copy_worksheet
>>> source = wb.active
>>> target = wb.copy_worksheet(source)
For older ones you can probably copy the source code from here
UPDATE: You can't simply graft this code into older versions of the library
Solution 2:
You can't do this easily. The best approach is probably the one described in bug 171