Report criteria based on two sheets, matched on row

Is it possible to create a report based on data from two sheets, but criteria is include only rows where the entry in primary column in one sheet is identical to the entry in its counterpart column in the other sheet? In other words, matched on rows? I don't see where to set this in the report builder.