When copying sheets to another worksheet or new workbooks, you may not copy the charts or the images over. One of the reasons is that the button of "cut, copy and sort inserted objects with parent cells" is disabled. Please follow the steps below to change back:
Step 1: Click the "File" Tab from the ribbon;
Step 2: Click "Options" from the left navigation menu;
Step 3: Click "Advanced" from the left navigation menu in the dialog box;
Step 4: Check "Cut, copy, and sort inserted objects with their parent cells" under the section of "Cut, copy, and paste";
Step 5: Click "OK" at the bottom.
