Create Huge Editable Database in User Friendly Way

look at the table in your sheet 'Order Database' - use 'proper tables' - do not have merged cells within the data storage/manipulation areas.
with your tables have every relative cell filled and no empty rows in the table or at the end of the table otherwise you will have to introduce complex searching procedures.
referring to your second post - set out on a sheet an example how you want the data extracted.