Macro to copy and paste rows to a new sheet based on criteria

[Belo]

Hey guys,

I have a workbook in which i have lots of different sheets with the same formatting, what i am trying to do is have a macro automatically copy and paste rows from these sheets to another sheet named "overdue payments" if they match a certain criteria.

The criteria is in column K with the option of "Yes" or "No". I want the sheets to copy and paste if the answer is "No"

also i would like this to automatically update when the answer is changed.

I have attached a sample workbook for you to understand what i am talking about.

I would really appreciate some help as i am now really stuck! i know it can be done but I'm just not sure how to write up the macro!!

Thanks in advance