Question: how to copy multiple rows from one excel sheet to another?
Answer: Select the rows that you want to copy by holding Shift (select a range of rows) or Ctrl (select disparate rows) and clicking the desired rows numbers on the left side of the sheet grid. ... 
Right-click on the highlighted selection and choose Copy to Another Sheet.