Help with formula to do a lookup to copy all columns and rows from 2 worksheets that match

Hi Everyone!


On Delete worksheet I need to do a lookup to copy all columns and rows from both Ruhle_customers and Ruhle_prospects worksheets that the first column says No-Delete.

I attached a portion of my workbook as an example.

I cant get it to pull from both worksheets......

Can anyone help me please!

Thank you in advance for your help!