I've simplified the steps required in this example to add the data in a similar fashion. Ranges are all dynamic, so you should be able to add more terms to you database without having to modify the code.

Another approach I considered was to use VLOOKUP to fill all the data at the start, but set the Font to white. You could then change the Font colour of each item in turn.