Copy a cell and give paste for each name in dataset

I'm not too sure how to explain this but my example document shows how I need a macro to work.

Search for "Name", offset 0,-1 and copy, then offset 6,1 from searched word and paste and drag location down for however many names are in the dataset

Thanks in advance.