Inserting rows/copy data from row to column

Hello,
Hopefully someone can help me solve a problem I am having creating a macro to insert rows into a spreadsheet then copying data from the row into a specific column.
Currently all the data is on one row, with several rows in the spreadsheet. Columns A-R remain the same, but columns S-Y, Z-AF, AG-Am etc have different report data. I want to be able to individually copy the data from those columns and line them up under each report.
So if the rows currently look like:
Name Address City State Zip Child1name Child1Age Child1DOB Child1sex Child2name Child2Age Child2DOB Child2sex Child3name Child3Age Child1DOB Child3sex
I need to figure out how to insert a certain number of rows, based on the number of children, then pull the data from the row into the column in the new row.
So for this parent, there will be two new rows and the data now will look like this:
Name Address City State Zip Child1name Child1Age Child1DOB Child1sex
Child2name Child2Age Child2DOB Child2sex
Child3name Child3Age Child1DOB Child3sex