I have a file with about 10 worksheets, each one has a name of an employee. One of the sheets contains all the info about the employee. On this main sheet I would like a cell to reference a named worksheet which matches the names that appear in the main sheet list. From that worksheet I would like a formula that gives me the score referenced from each individuals sheet. I have attached a small example file
Thanks
Bookmarks