I could be completely wrong, but I believe you will have to select each sheet, then choose what to copy and paste. Something like...

HTML Code: