I am trying to rename the new sheet being copied over to the target book: Masterworkbook.xls which after the sheet is copied over, is Sheet1.

I do not wish to rename the original Sheet name in the Source workbook, but in fact leave it as is.

If your edit to my code was supposed to fix, it did not, I still get the Object Required error.
I do not fully understand the double qualifying point you are trying to make to me.
Do I need to tell it this is to now be a string, or variant, Dim wkbName as string or variant?