Either:
a) Define your table on sheet Calendar as Table, and refer to it using Table formula syntax;
or
b) Define the range 'Due_Production_Date_Data' as Dynamic Range,
like:
Due_Production_Date_Data = OFFSET(Calendar!$A$1,1,,COUNT(Calendar!$A:$A),5)
|