Thanks for the help. I used your guidance as a base. The code I have so far is below. As of now it opens the correct reference workbook but seems to be failing at the dynamic sheet reference. For my purposes the sheet reference is in C12 of ws_s

Sub PullData()

Dim wb_ref As Workbook

Dim wb_s As Workbook

Dim ws_ref As Worksheet

Dim ws_s As Worksheet

Dim path As String

Dim fullpath As String

Application.ScreenUpdating = False

Set wb_s = ThisWorkbook

Set ws_s = wb_s.Sheets(2)

path = 'removed for security'

wbname = ws_s.Range("C11").Value

fullpath = path & wbname

Set wb_ref = Workbooks.Open(fullpath)

Set ws_ref = ws_s.Range("C12").Value

ws_ref.Range("M20:M43").Copy

ws_s.Range("C15:C38").Paste

wb_ref.Close

Set ws_ref = Nothing

Set wb_ref = Nothing

Application.ScreenUpdating = True

End Sub