Tables :: Converting A Spreadsheet To Access Database

I have been tasked with converting a spreadsheet to an access database. I work for a growing firm of Tree-Surgeons (no pun intended), who service a sizeable chunk of the power grid in the UK. At any time, we have up to 150 operatives in the field, cutting vegetation around power lines. Because of the obvious danger, the power company need advance warning of where any teams will be cutting on any given day.

Various team leaders call in each day and give their intended locations for the following day to an individual who's responsibility it is to log the info onto a central spreadsheet, an Excel workbook. Each workbook contains a worksheet for each day (Mon-Fri). Each worksheet contains the following fields:

1. Number (Unique Numerical Sequence for the individual)
2. Name
3. Phone Number
4. Working/Not Working
5. Type of Line (132kv, Extra High Voltage (EHV), High Voltage (HV), Low Voltage (LV))
6. Area (in this case a lookup of 8 geographical areas)
7. SubStn Number (a name of exact location followed by nn/nnn) (LV Only)
8. Circuit and Pole Numbers (a location followed by nn) (HV Only)
9. Locality (nearest village/town)
10. Grid Reference (nn/nnn/nnn)
11. Time On-Site
12. Time Off-Site

So far I have created a table (Called Contact) for the individuals:

ContactID (Key)
ContactTeamNumber
ContactFirstName
ContactSurname
ContactMobileNumber
ContactTitle
ContactStatus

[code]....

Team Members can move between teams, but Team Leaders remain largely static.I guess I should create a separate table for Team Leaders and Team Members, with a one-to-many relationship between them? All of the others could be around the network but would not be attached to a Team Leader, so I guess they can be in the same table as Team Leaders for the purposes of tracking their location.

Also, what is the alternative to using a look-up for some of the fields, for example the Area field? I was concerned about breaking one of the commandments, and cant see a reason why, but I await enlightenment!