Autofill Down and Across based on Data on another Worksheet

[uberathlete]

Hi everyone, and Happy New Year! I was hoping to for some assistance with a problem.

Basically, all I would like to do is run a macro that grabs data from another worksheet.

Please see attached.

In WORKSHEET, there is a blue highlighted area. Those cells should be populated with data in the Parts Usage tab. Basically, column D should list a Part, column E the Quantity, and column F the Price or rate.

The desired result is in the Result tab. I basically just entered a formula then autofilled down and across. Is there a way to do this in VBA? Any suggestions would be much appreciated.