@Jeff. Thank you so much for your speedy and extremely helpful reply. Being a noob to VBA, I am not surprised that there is room for improvement with the optimization of my code, however, thanks to your reply, I was able to get the functionality and that was the first big hurdle.

As you most likely noticed in the sample code, each of the macros, will ultimately move all of the contents of Sheet1 to Sheet2 and rename both. Following this step, I need to bring the contents from Sheet1 in an external workbook into the one with the macros. I assume the syntax would be very similar to the move from sheet to sheet, however, can you, or anyone share the syntax needed to reference an external workbook?

Peace and respect,