Using Find Method Excel VBA

[Andreew]

Hi,

I have developed a movie list to store information about my movies (movie name, date added, location etc.)

I am using a simple Find method to seach for a movie in the list. The movie names are located in column A and the movies' binder (location of movie) is stored in column D. When i search for a movie i have the results transferred to another sheet for easy veiwing. So far i can search for a movie and view all movies containing that phrase in the new sheet but i cannot work out how to also search/view the corresponding binder for each movie and have that copied across also, any help would be greatly appreciated. I have included some pictures to better explain what i can't lol.

Capture 1 = Sheet that stores all the movie information
Capture 2 = Current code i am using as Find Method
Capture 3 = Sheet that search results are copied to