I'm sorry if this question has already been answered, I tried looking for it in the forums and I'm sorry if I missed it.

I have an invoice spreadsheet template that I use to bill multiple customers. I'd like to know the easiest way to plug in a specific customer and address into the "To" field of the invoice from a pre-made list of customer addresses. I read about drop down lists which looks promising but I could not understand how to do it. Would this be the easiest way? Or would linking it from an address list in sheet2 to the invoice that is sheet1 be easier?