After posting a question on this site, I followed the prompt very helpful
advice and now have my wonderful order form of which I am very proud.

I created a data range and named it "products" to make it easier for the
VLOOKUP formula. Now, I need to add some more products to this range. I
have tried to drag the range box over the new lines but it over writes them
with data from row 1, but doesn't then include those duplicated rows in the
new data range - it still remains the same. I've tried dragging the box over
the new rows of data whilst pressing Alt, Ctrl, Shift, A, B, C everything!!!
It just will not add the extra rows into the range.

Your help would again be most appreciated.