Sub CopyTabIntoAnotherFile()
Set wbks = Workbooks.Open("C:\Users\JPP\Desktop\Excel KDP\Historian\860 - LabImport Raw Data_November")
wbks.Sheets("860 - LabImport Raw Data").Range("A1:F" & wbks.Sheets("860 - LabImport Raw Data").Range("A65536").End(xlUp).Row).Copy wbkc.Sheets("Copy Historian Macro Template").Range("A1")
End Sub