Hi I have a problem with getpivotdata function

Hi I got a file which I need to populate with the latest sales figure from a pivot table. I checked my get pivot data formula, is correct but it keeps on returning the #ref error. Can someone help me...