Referencing Sheet Code name

Hi All,

I have a regular excel extract that im obtaining, however the sheet name is never the same, it is a reference of the system run number "report1442310827144"

Im wanting to reference the sheet and from what i have seen in forums is that you can use the sheet code name. In this case it is "sheet1".

However when i go to reference the sheet code name, i seem to have an issue

My original code is below:-

With Workbooks(fname).Worksheets("report1442310827144")

            Set rngeSource = .Range("B19", .Range("D" & Rows.Count).End(xlUp).Offset(-12))
        End With

Any help would be greatly appreciated!