when I view the sales form and choose company 1 it shows an employee name under company name header, and a date under bottle sizes header.

When I choose company 2 it shows under company 2 header company 1 and under the bottle sizes header it shows the brands for company 1

and

When I choose company 3 under the company header it shows bottle sizes information, under bottle sizes header it shows units sold, under weight header it shows Std UOM Conv information, under pieces header it shows whether or not it is case or a single (cases = CA, singles = Eaches)

Ok weird I reloaded the user form like 3 times and the information loaded correctly but initially it was showing the information as described above.

Two comments I have is the header for the company name I would like if possible for it to say: "Company 1 (Brands)" or just Brands since the drop down box to the left already establishes that the information is for company 1
Also the formulas I had in the spreadsheet, I would like something along the lines of that functionality added, either formulas to grab the information and then a paste special to get rid of the formula, or when the sales information is added to have the other background information added as well. The user doesn't need to see this information before it is inputted into the sheet.

After hitting enter data on the sales form, all of the information on the sales sheet that I have in place already, should be shown pertaining to what the user inputed. After further consideration I believe that there should be a choice to show bottles per case since it is possible that a brand might have the same bottle size, flavor and everything and the only difference could come down to how many bottles are in the case. I think you call this pieces. So ultimately what the user needs to choose is brand, bottle size, and bottles per case (pieces) and the rest should be populated for them automatically.

Does all of that make sense?