Using a drop down box to fill a cell

Hi,

I am trying to use a dropdwon box to populate a running stock cell which is dependent on which is the current period, the running stock is exreacted from the opening stock minus any stock issues and inclusive of any deliveries to produce the current stock level for each item please find attached a spreadsheet with the details on