In order to help you, we need for you to post/upload your macro.
See
If you are doing a Copy for each cell in Numbers, you might want to consider using AppleScript to read each cell, and set the appropriate KM Variables. I think this would be much more reliable than a Copy-TAB approach.
If you do a Google search on "AppleScript Numbers", you should find lots of example scripts. You can also search this forum for the same.