Hi,
I want to look at sheet 2, sheet 3, and sheet 4 to see if there's an "Open" issue. I'm thinking a Vlookup, but I can't figure out how to look across multiple sheets. Punch List Workbook.xlsx

If the status column is "Open" in any of the sheets, I want all of the information in the corresponding row to carry over to Sheet 1. Does anyone have any ideas?