I am working with a multi-sheet Excel document and need to create a new sheet that shows the rows from all the other sheets that meet a certain criteria. For example, I might have rows on sheets 1, 2, and 3 that all have "Smith" in the last_name column. How do I write a formula/function that will automatically pull rows from these various sheets?

Thank you!