Excel: exporting rows that meet criteria

Hello,

I'm new to this forum and also to macros so please excuse any technical slip-ups. Thanks in advance for help! I currently have two Excel workbooks, Child Data and Woman Data. I need to merge these two into one workbook, but with the caveat that not every woman in Woman Data is a mother of a child in Child Data. There is a column in each workbook for Woman(Mother)ID, and what I would like to do is create a filter such that I can export rows in Woman Data where the entry for Woman(Mother)ID matches an entry for Woman(Mother)ID in Child Data. Some women have more than one child, and so this also would need to be able to export some rows multiple times. For example, Child Data looks like this:

Child ID Woman(Mother ID) Child Var1 Child Var2 Etc
10 1000 0 1
11 1000 0 0
20 2000 1 1

And Mother Data looks like this:

Woman(Mother ID) Woman(Mother)Var1 Woman(Mother)Var2 Etc
500 0 0
1000 1 0
1200 0 0
2000 1 1

Thanks for any advice!