It is because the sheet contains MANY more columns than the ones I defined in the question (trying to keep my question simple). And several of those columns would be very much in the way. Therefore, I was hoping to use automation to either copy the rows with columns that contain needed details that match the criteria, or create a linked section in some way....but again I need guidance.

Sorry, I can't put it all on one sheet.