It might be quicker to just Copy the entire sheet and the delete the rows you don't want. Right click Sheet 1, "Move or Copy", from the drop down select the spreadsheet you want to copy from (by default it will be the one you are working on), in the list box you will see "Sheet 1" & "(move to end)", highlight "Sheet 1" (if not already highlighted), tick the "Create a copy" tick box at the bottom and then OK. Then on the copied sheet just delete the rows you don't want.
I'm sure there will be a Macro way of doing it but it will probably take longer to create than it would to just do the above.