There's a couple of ways to do this.

The easiest way and the one that will impact performance of the file the
least is to use a filter. Add a column to the end of table and enter this
formula:

=IF(AND(A1=Sheet2!A$1,B1=Sheet2!A$2),"x","")

Copy down to the end of the table.

Then filter on that column using the "x" as the criteria. Then copy the
filtered list over to sheet 2.

That's the easiest way to do this but it isn't dynamic.

You could do this with formulas, but, depending on how much data needs to be
searched on sheet1 and how many records need to be pulled over to sheet2,
this can impact the performance of the file (slow things down).

How many rows of data are there on sheet1 that need to be searched? If it's
1000's then you will want to use the filter method. If you still want to
consider using the formula method let me know and I'll put together a small
sample file that demonstrates this and will put up a link to that file.

Biff