I have a workbook consisting of three different worksheets that all contain the same column headings, Project Name, Value, and Status. In a fourth worksheet in the same workbook I would like to extract the data from the any row on all of the sheets where the Status is equal to "Closed". In other words on each sheet in rows 5 - 20 I have the three columns of data. In the first worksheet two of those rows have a status of "Closed" and in the next worksheet three of them have a status of closed. I would like to create a formula that gives me all five rows containing the data of all three columns in a separate worksheet (i.e., I would like to have all of the "closed" data consolidated in one place). Thank you in advance for your cooperation.