I have a report that needs data from another workbook to be put against the
names of people.

The names on my report are always the same and in the same order, but the
other workbook is updated each month, and the names will be in a different
order. From the second file i need three of the cells copying over to my
workbook, and i would like this to be done automatrically as there are about
150 names.

If i run a macroo to find the names, and then select he cells on that line,
it just selects the cell location, and when i do the next months it picks up
someone elses info as the cell location for that name had no changed.

Please help.