Copy Data from workbook into another based on certain criteria

Hi very new to this with limited ability. I have a workbook that has separate sheets for each week of the year. "week 1" "Week 2" etc. it contains information for invoices sent with a column to record if they have paid. The column is blank if they have not paid and "YES" if they have paid.
I want to extract the information for all those who have not paid into a new spread sheet with all the row data. The workbook is updated daily and the new spread sheet would need to change accordingly. Sorry if I've not explained it very well.
Many Thanks

Would this be of any help? Assumes Column B has the data "Yes" or blank.

Please Login or Register  to view this content.

Two files attached as suggested. Many Thanks

Many Thanks for this. Im going to be out the office for a few days but will give it a try as soon as im back in.
Thanks for taking the time.