I have a fairly large workbook of 76 tabs with the main, "master sheet" having around 2600 entries. The others have anywhere from 50-250. They are alphabetical list of contractors with the areas of work as the differing tabs. My goal is to cross reference the master list of names with the other tabs to see what contractors are registered for what area of work. I am trying to derive a function that look up the text and tell me which tab(s) each one is located. I have been plugging away for some time now with little success. Any help of ideas for formulas or way to organize the data would be greatly appreciate since this is my first major excel project.