Volunteer Roster Help

First of all, my experience in Excel is very, VERY minimal.

I have a Volunteer Spread Sheet created in Excel. It has a number of categories where volunteers write in their hours after each stint. Each volunteer has their own sheet. In the header of each sheet is a place for the volunteer's name and phone number.

On the second sheet of the workbook I have created a master volunteer sheet with the name of the volunteer in column A and phone number in column B.

Currently, each year we hand-type in the name and contact info on individual sheets. I am sure that with Excel, there must be a way to tell sheet 1 to populate the contact info from sheet 2, but I don't know how, or because of my limited knowledge of Excel, when I tried to Google the info, I don't understand what it wants me to do. Can someone explain how to do this in PLAIN ENGLISH? There are over 100 volunteers and it takes hours to do this by hand.

Thank you for any help!

Okay, I went in and for volunteer privacy reasons, made some changes and then re-saved, but I did not change the meat of it. I did not create the Volunteer Time Sheet---that was someone else several years ago. I did create the Volunteer list on page 2, but as you can see, not highly complicated. I thought it would be easier if all the info I needed to merge, populate, move around, whatever---was in the same worksheet.

As long as the basics remain consistent, I can add, remove, re-size cells so that what I want to do can be done. Again, the person who created the original time sheet was like me---minimal Excel knowledge---and they might not have set it up correctly with the header and name and phone number places.

At my old job, I used to see IT and Admin do amazing things with Excel and I can't believe it's not something really simple, if 1) you know what you are doing; 2) someone explains simply what to do.

I appreciate any assistance. We are a small, non-profit museum run by volunteers and we don't have the funds for hired-gun IT help!