Automatically consolidate table entries and reformat

Hi Ollie, it looks like your last post was great, this is really close to what I need.

A few quick questions - I'm trying to change the names:

So "dog" in the Input should become "wolf" in the output, and "cat" should become "lion" in the output worksheet.

How do I change these?

So right now,

Cat -> Lion, but I want it to be "123" -> "321"
Dog -> Wolf, but I want it to be "567" -> "765"

Whenever I try to swap the names in the code and run it, it tells me there is a type mismatch error in the strKeyValue lines.

Thanks for your help OllieB!