Question: how to copy data from one excel sheet to another in mac?
Answer: Hold down OPTION.
Drag the sheet tab to the location that you want the copied sheet to appear along the row of sheet tabs. Important: Release the mouse button before you release the OPTION key.