How to Auto Fill data from on sheet to another

Have a friend who asked me to create and "Appointment Page" he can print out and give to his sales people. Both sheets are included in 1 workbook. Each line of data on the first sheet has a unique number in column A. He completes the information when he receives a new sales lead. I would like to use this number on the second sheet to "call up" the appropriate information from sheet 1 and post it into sheet #2.

Sheet 1 -- Contains data he enters
Sheet 2 -- The Appointment Page I created for him.

Also, is there any way to save sheet 2 ONLY in a separate file for future use?

I've attached a "sanatized" version of the workbook for you to look at.

Thanks a bunch for any help you might render.

Papalue