Moving data between sheets

Good Afternoon Everyone!

This is my first attempt at creating a macro to automate some manual tasks. Here is what I am trying to do...

On the attached workbook there are 3 sheets. "Original" is the source of the data, "Example Report" is a mockup of the result I would like to see, and "Attempt" is what I am working on so far.

My current strategy is to take the "original" items and remove all the things I don’t need, resulting in the list found on the "attempt" tab.

Then my thoughts was that I would create a new sheet, and iterate through the list and every time I encounter "Name" make a new column on the sheet and continue working my way through. (See "Example Report")

The trick is that I have no idea how to iterate through the list and move the data to a new sheet!

Any assistance is greatly appreciated.

-Kevin