Help on designing a workbook

My levels are limited.... I can do simple things like COUNT and some IF, Datasorting, etc.

I could make these sheet do what I want, but only in a very long winded and mostly manual way. It needs to be pretty fast.

I've got my basics here in an attachement. I used to have it so that the price per unit autofilled to correspond with the unit type cell, but someone took it out and I've forgotten how I did it (not my fault, I have small kids and I'm expecting again. Memory is not my strong point at the moment due to extreme lack of sleep!)