Reporting from a list

[IGPOD]

I have a list of contract names. I have to provide a status report on contracts that are not fully signed. In Column "A" I have the contract name. in Column "M" I have the Date the Contract is/was completed.

My report lies in Column "N"

What I need is a macro that will search that list of contract names, and based on a blank cell in Column "M" it will provide me ONLY the contracts that are not completed (blank "M" column; because not completed) and only the Contract Name (Column "A") along with the contract notes in the "N" column.

I know someone out there can figure this out much faster than I... I've been trying for days, I can't get anything to work and this is always my goto resource.

I need to report this information onto another sheet in the same workbook... basically using VBA to reference the cells and import the content on my reports page at the click of a button.

Thanks in advance!

Here is an example of what I'm working with:


I just need the capture the information in the yellow and report them to another sheet (sheet2)