Greetings!

I am currently looking up a way to do a report and i am trying to take rows of data from sheet 6 and automatically copy it in sheet 4 if the drop down option of "Missing Documents" is chosen in column D on sheet 6.