Linking data from one sheet to another

[geefer]

Hey guys. Not that well versed in Excel but my boss would like an easier way to write out invoices. If I can get some help I will gladly pay for your time or donate to a charity on your behalf.

We currently just type out all the customer's info while they're standing there, then print and give to them.

I'd like to be able to just type in the first name and have it auto-populate with what they bought, price, address, etc.

We already have one sheet with all that information on it.

I deleted all the personal information and just left the headings at the top so you can see what cells hold what info. Whenever I try to cut/paste our invoice into Sheet 2, it will freeze my computer upon trying to save, so I have 2 attachments. One being the invoice, one being the database of customers. I can't save the invoice as a .XLS file for some weird reason, so I saved it as an Open Office Document.

I'd like it so when we type in the person's name, it will auto-populate the following:

Telephone
Address
City, Province
Postal Code

And I think that's enough. If anyone would like to have a crack at it, I'll host the file below. Like I said, a donation will be made for your time, and please let me know if you're willing to help again in case we have any other questions, or perhaps want to expand on this in the future.

Many thanks from Pat.