I'm not quite following what you mean?? However, can I have the code choose data from the current workbook instead of choosing the data source? This way it would merge with the excel book that contains the updated information instead of the template that is used?

What you currently helped me out with works, but I need it as simplistic as can be. The people using this would not understand how to choose data and then the list. I was trying to get it all under one click of a button, but maybe I'm trying to do something not possible. Thanks