Excel Macro needed: Comparing and rewriting cells in different tables

Hello Folks, i have to solve the following issue: There are ten Excel Sheets which are sent from different destinations from time to time. I call them "Compare-Tables" And there is one Excel Doc which is an export from a online shop. I call this File "Export-Table". In the Export file there is one Column with Codes. AI, red background and in the tables you'll find Codes and Names of cities which belong to one data set / row. The task is to write a macro which automatically compares the Codes of the Export-Table with the Codes of the Compare-Tables and read out the City for each Code. Finally the City for each Code should be written in the field CN "Bestell17", coloured yellow. The Macro must do that automatically for all of the eleven Tables. Each Code is different. You got it? Budget is about $ 50-60 If you can do that, please make your offers soon. We need a 100 percent working macro on Monday. Thanks!