Private Sub CommandButton1_Click()
Dim sourceworkbook As Workbook
Dim currentworkbook As Workbook
Set currentworkbook = ThisWorkbook
Set sourceworkbook = Workbooks.Open("C:\Users\Robert Sindo\Desktop\JMI Inventory Analyst Master Files\JYKO\JYKO SKU Masterlist.xlsm")
sourceworkbook.Sheets("Quickbook").Copy after:=currentworkbook.Sheets("QB Uploader")
Sheets(Sheets.Count).Name = InputBox("ASSIGN A NEW NAME:")
If sourceworkbook.Value = "" Then
MsgBox "There is no data in your selection."
Exit Sub
Else
sourceworkbook.Sheets("Quickbook").Select
End If
sourceworkbook.Close