I've tried V-Lookup but dont think its the function I should be using.
I need to Filter a column for specific information & then I need the results
to be entered on a different worksheet.
E.G: (SHEET1)
A1 - "Billy", B1 - "Tolin", C1 - "AEA750", D1 - "Grey"

Sheet1 D1 - "Grey" (Word to be searched)
Sheet1 D:D (Column that needs to be filtered)
Sheet2 - I need all the information inserted from: A1 to C1

So, I need anyone with the word "Grey" in Column "D:D" to be inserted on
sheet2 with all the other information in the same row.