=IF(A12="","",VLOOKUP(A12,ESTIMATE!$A$9:$B$15,2,0))

and

=IF($A12="","",SUMIF(ESTIMATE!$A$9:$A$15,$A12,ESTIMATE!K$9:K$15))

copied across and down or a macro

Sub UpdateFromEstimteSAS()

Set ds = Sheets("Budget")

With Sheets("Estimate")

Lr = .Cells(Rows.Count, 1).End(xlUp).Row

With .Range("a8:a" & Lr)

..AdvancedFilter Action:=xlFilterInPlace, Unique:=True

..Copy ds.Range("a17")

..AutoFilter

..AutoFilter

End With

dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row

ds.Range("b19:b" & dlr).Formula = _

"=IF($A19="""","""",VLOOKUP($A19,ESTIMATE!$A$9:$B$15,2,0))"

ds.Range("c19:h" & dlr).Formula = _

"=IF($a19="""","""",SUMIF(ESTIMATE!$A$9:$A$15,$A19,ESTIMATE!K$9:K$15))"

ds.Range("b19:h" & dlr).Value = ds.Range("b19:h" & dlr).Value

End With

End Sub