If function

Is there a way to create a formula where data gets pulled into another sheet, within the same workbook, if and only if certain criteria are met?  For instance, I have a master tab where information ...