Dear experts,

I am writing to request some help, allowing me to extract rows of specific columns from sheet1, where name is present in columns A, into sheet2. I have an example file attached below, which shows sheet1, as input data and sheet2, as desired output.
final_extraction.xls

Please advice and any guidance would be most appreciated.

Thank you all.