RJ, I see that the Production Sheet has many merged cells. Merged cells are an anathema to VBA and make it very difficult to work with Ranges, especially Named Ranges that include Merged Cells.

Example using val_FileNameRef, which refers to Production 5S'!$B$2, a Merge that includes Range("B2:F2") 
X = Range(val_FileNameRef).Cells(1)
IF IRC, .Cells(1) is right, But it might be .Range("A1") instead. There may even be more to it than that : Se below

You can eliminate all Merged Cells on the sheet and use some creative Cell Formatting of Horizontal Alignment, (Center Across Selection,) and White vertical borders to keep the same appearance.

I note that some Named Ranges use the same Name on two sheets, one as a Global Name, and the other as a Sheet name Example val_Date
On the Audit Assignment it is a Global Name, but on the Production sheet it is a Sheet Specific Name 
'Using Merged Cells
AuditDate = Range(val_Date).Cells(1)
ProductionDate = Range('Production 5S'!val_Date).Cells(1)
Even though I always design Excel Projects to only use Named Ranges in Excel Formulas, (Never in VBA,) I always use a Sheet Reference prefix. Example: pro_Date, and aud_Date.