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 sp...