Hey thanks so much for your help!

To answer your questions:

1. The tax rate does need to be on sheet 1 as later I will add tables to enter customer information and the tax rate changes depending on their location.

2. They are sorted in the order that I will most likely use them.
I would however like to be able to type in the box and have it match up to a selection without having to scroll down and click it. If possible I want to be able to not just type the first letters of the word, but to have it match up to any part of the line item.

Example: I type "water" in drop down 2

It populates with "Ice & water shield

I want to do it that way because I have a lot more data in the real workbook and a lot of the choices start with the same first word

3. I have a different worksheet that is updated periodically for the prices. I copy and paste the new prices to my invoice work book. The price worksheet gives me a flat tax rate at 5%, I then do [Tax 5%]*0.2*100 then *Tax Rate on sheet 1, to give me freedom in choosing the tax rate for each different invoice.

4. I may just simplify the names in the first category as to not over complicate. But I may like to know how to do that in the future

There's one other thing though, and this is what I have the hardest time explaining. I dont want there to be a fixed amount of rows there are in A4:G16. I want to be able to create an entry, and then the next row automatically populates. If I don't use the row, I don't want anything to be there, and I want the grand total bar to automatically adjust to be 2 rows down from the last entry

You've pretty much got what I'm trying to do, that's awesome man. Again, thanks so much for your help. I'd love to know how you went about doing it.