In a worksheet (Ansatte) i am having a column with names in the range A4:A41, i named the range "Navne".

These names are copyed to 8 other sheets.
On these sheets code is looking up corresponding values in the sheet (Ansatte) in columns D, E and F and showing the name and these values in the statusbar.

In order to have the lookup working correct the names must be unique and contain no space.

I attach the sheet in question.