Assuming that the layout will not change, but the lines of data might...

you'd need
- a variable for the title
- a variable for the section
- a variable for the end (last row of data)
- a variable for the current row on the dest sheet that you are at

You'd also need a reference to the workbook, sheet, and a variable for the range.

Pseudocode would be something like:
Read in the title, the section
Loop the following
write to the destination sheet the variables held
read in the item and write it to the dest sheet (hold in a variable)
read in the values and write them as new rows including the held variables
move output pointer as each line of data is complete
move to next line of data
Exit if no more data rows to read


Have a go first, and post up some of your code with any error messages. If you are doing this for a course, they should cover some of the different ways to do this in it.