Pulling data from once Workbook into another Workbook

[zendog1960]

I have a workbook called Employees. This workbook contains the names, addresses and contact information for my survey field crew members. This is a workbook that will be updated as more people are hired.

I have a workbook called Crew Schedule. This is used to schedule crews to specific tasks for the day.

Here is what I want to accomplish:

In the Crew Schedule workbook in Column A is where I put in the Crew Names. Since I do not want to type this information in or spend the time updating both the Employees workbook and the crew schedule everytime a new employee is hired, I want to use the employee workbook to automatically update the crew schedule with the current names in the Employee workbook. I would then create a data validation list of those names to be used in Cell A6.

Here is the Schedule Sheet:
-----------------------------------------------------------------------------------

Master.xls
	A	B	C	D
5	CREW	JOB #	Job Name	Task Description
6
7
8
9
10
11
Sheet1

-------------------------------------------------------------------------------------

In A6, I want to use a validation list based on the following, which is the employee workbook:


-------------------------------------------------------------------------------------

Survey-Employees.xls
	A	B	C	D
1	Employee Name
2
3	Frank Burns
4	Hot Lips Hoolihan
5	Radar
6	Spongebob Squarepants
7	Bugs Bunny
8
9
Sheet1

-------------------------------------------------------------------------------------

Can anyone help me get this to work? What I would like is that when the Crew Schedule is opened, it looks at the Employee workbook and updates the names in the Crew Schedule workbook. It would be extremely nice if this could be done so the end user does not see it happen. What I mean to say is that I don't want the employees workbook to open up on their desktop but rather have this operation be hidden from the user.

I know this is a bit complicated so if it would be better to contact me just let me know and I will send out my contact info . I would rather try and get this done through the board so I can learn this because I have other things of similar nature I would like to try but this is the first step..

Thank you in advance for your help in this problem.

 

[zendog1960]

Does anyone have any suggestions at all or is this even possible?