HELP!! Create Multiple Pages within a worksheet from another worksheet

Hi All

I have a workbook with multiple rows. I want to create multiple pages of sheet 2 based on how many rows I have in sheet 1. Then import information from each row on sheet 1 into various cells in sheet 2. Can anyone help me please. I have seen lots of thread on creating multiple sheets but I want to duplicate pages of a worksheet within itself. I am in a bit of a bind with time so any help would be grately appreciated. TIA