Excel Marcos for lookup and entry

Hello,

I need to create a spreadsheet to enter truckload orders of produce. This produce list of items could be 100 items long, these are number down a column (column b,) with one item per row. Currently we just enter the amounts needed by each line for the truckloads, with truckloads going across the top of each column (truckload 1 in c2, truckload 2 in d2, ect) . There are mutiple truckloads each week.

Is there a way to make a macro to have someone key in the truckload they are making, say load 1, then type apples in a cell and enter 20 in the next cell (for quanity in pounds needed on truck one) and have excel find corret column that corresponds to truck "1" and then find the apples in the correct column and row, and add the nuber 20 that was entered? After that is complete, blank out the search item (apples) and the quanity needed, so we can enter the next set of data. Say oranges and 25.

Thanks