anyone know how i can set a variable equal to a value from a pivot
table that is part of another sheet?

i tried

dim amount as double

amount = GETPIVOTDATA("YTD Total Units",[PERSONAL.XLSB]Sheet5!$A
$3,"SIEBELLINKID",sid,"CU_CODE","IPPRO")

but am getting an error. can someone please help me with this.