checklist dropdown function

I need help with creating a function in a workbook I created. Here's the deal. One tab has a worksheet that has 2 columns. ColumnA has text (inspection criteria) the other tab has a dropdown list with "YES/NO". When "YES" is selected in columnB, I need the checklist description copied onto the next tab which is the report tab. There are musltiple rows of descrptions on the first tab that may be copied onto the report tab.

How do I write this function? All I need is for columnA on the inspection tab to transfer to the report tab.

Please help as soon as anyone can.

Thanks.