Quote Originally Posted by GTO
...Are we copying from just one sheet or many?

What are the sheet names, etc.
Sorry, you still are not saying whether we are copying from many sheets in Names.xlsx or from many sheets. See, that would change how we would write the code, so it is best to paint us the clearest picture you can, of what the code is truly to do.