In fact the formulas are calling values that are found in another workbook
this is why you get the N/A
=HLOOKUP(Month,'H:\Submitted Packs\[CoA Ltd.xls]JVB'!$D$4:$P$57,ROW(C5)-1,FALSE)
so in fact...if u have the JVB sheet in the worbook your working on, you can delete from the formulas all the red marked sentence where the data should be looke for the HLOOKUP