根据另一个表中的值将数据从一个选项卡复制到另一个选项卡

I have a table "RawData" in excel I would like to filter. Column A has a name, and Column B has a number. I would like to copy the data to a different table, "LoadingData", if the name matches up with a specific number. I have the corresponding names/numbers in a different tab "ShiftData" within the worksheet. I have a table "RawData" in excel I would like