Macro to copy specific entries and adjust value based on a table

Hi All,

Happy Holidays everyone!!

I could use some help with the following goal. In the attached file, I have an Import tab that shows 5 columns. I need a macro that only copies entries where the value in column D is equal to one of the values in the Adjustment Table tab.

So in this case, whenever a row with a value G, H, or J in column D, the macro copies the row into the Export tab, and adjusts it based on the value next to the adjustment name. So in this case, all entries with "G" in column D will have their "E" column adjusted with an increased 2.2%, and placed into the Export tab.

I think the example in the attachment will make more sense.

Can anyone assist me with this?

Thank you!