I have table A, which contains thousands of rows. This table has an ID to every row.

Only part of the rows in Table A interests me. Thus, I have created a second table, B, which contains only one column, ID. Table B is the criteria for extracting the relevant rows from Table A.

I want to create table C, which will contain only the relevant rows from A.

Another issue: data in Table A changes frequently.

How do I do that in Excel? Preferably automatically.

Thanks