Sorry if title is confusing, i have this vba script which works fine
It loads up a sheet from another workbook.
Sub LoadSheet()
Dim FileName As String
Dim WS1 As Worksheet
Dim WS2 As Worksheet
Dim ActiveListWB As Workbook
ChDrive "C:"
ChDir "C:\users\jay\desktop"
Set WS2 =...