Copy row of multiple sheets into a target sheet when condition is met
I have 2 sheets with same number of columns (with exception of Function Group name). I would like to create a master sheet also with the exact same identified columns. When a condition is met, i.e, Task is in critical path, then copy the row from the sheet reported that condition into the target sheet. Basically the target sheet is the collection of all tasks that being identified as in critical path. What is the best function to use to achieve this? Please advise! Thank you!