I'm sure people have asked this many times, and I have honestly searched for the answer on this forum but I haven't been successful, so I'd be grateful if someone would direct me to a previous answer, or help me to solve this.

I want to print a bunch of invoices by mail-merging from excel.
In my first worksheet, I have:
CLIENT NAME | ADDRESS | JOB | AMOUNT | DATE etc
This is the 'overview' sheet from which I'll do the mail-merge.
I have already done drop-down lists for the jobs / amounts etc so they can be chosen easily.

My problem is that I want to populate the first worksheet from a separate list of names and addresses (in sheet2), and I want to be able to click in the cell on sheet1 and automatically see sheet2 which is the database of names and addresses, and select the name I want, and I need the name and it's matching address to automatically populate in a row in sheet1. The database I have in sheet2 has the names and addresses broken into different columns so that I can do the mail-merging labels etc.
I have looked at VLOOKUP but the problem is that I really need to see the whole list of names and addresses to be able to select the one I want, rather than fill in a formula / number.

If there is an easier way to generate invoices from a database of clients, I'd be happy to try it.

Sorry if this is in the wrong thread or if it's been answered a million times.

Thanks so much.

D