Extract some rows in Excel

I have one excel file and there are many sheets.All of the sheets have same data.I want to extract some rows i.e 5 how to extarct it