Vba/Macro Search Rows for value and copy/paste accordingly

Hello,

I am helping to manage ad inventory/ordering/small emails for a local home operation.
What im trying to do is take the data from the colored tabs and put it into the appropriate spot on the normal grey tabs by vegetable or fruit. Currently we filter the sheet then copy and paste the data. This becomes a headache when tracking 100s of veggies/fruits/flowers. Is there a way for a macro or vba to reference a list, filter for it, and then copy and paste the data in the correct tab? I already manually did this for Cabbage. Our sheets can turn into a couple hundred fruits/veggies/flowers in one month, so you can imagine how manually painful this becomes. Any sheet modifications or suggestions are warmly welcome.