Thanks a lot gyclone!

Is there the ability to set wb to equal the workbook the operator activates the macro button in?

My concern is that the workbook names will change, and I need it to work autonomously without coding changes if possible.

The biggest problem I see that I'm having is that the macro references the code in the source workbook after it's been imported into the target workbook. If I could get the macro to point to the local code (for want of the proper terminology) instead of pointing back to the source workbook, I think I would avoid having to create a variable.