Copy each row data of row headers with same value in one column. Help?

[zoenightshade]

So first I will choose the source file. Say I want to enter a name from the given sample. Then, I want to take all the amount and purpose under that name and paste it to the corresponding cells in the worksheet where i'm running vba. I dont know how to modify the code. Any help or leads on how I will start? Thanks in advance.