Excel to copy rows of the same unique ID and their values to another workbook

Hello,

I have 2 workbooks that I would like to link and do some automation. I would like to copy all rows with the same ID (Cindy) and their values from one workbook to another workbook with a spreadsheet named Cindy and Kim to a spreadsheet named Kim.

Any help is appreciated.