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.