Using information in one excel file in another
 

I am try to "automate" some systems at work to save time. We use an excel
spreadsheet to allocate Annual Leave. This is a file that contains a colum of
names and columns for each weeks of the year, were entered into the cell are
the number of hours staff have booked. We also have an duty rota in an excel
file. This contains colums with each staff member and the a row for each day,
with the shift expected to work.

At present some poor person goes through the annual leave file and re-enters
all the information onto the duty rota file.

I wondered if any one know how to link these files. I have been sussessful
to link two individual celss from each file using and IF formula. But often
people come and go, names are changed frquently and I did not want to put in
individual formula - since this would be time consuming to change them each
time.

Any Ideas
An Excel intermediate