Hello,
Currently I have a list of names on sheet 1. (named: names)
assume each name has a sheet that is named after it. (for the most part true)
I need to vlookup data that exists in each sheet (it moves around). I also have more then 500 names that change constantly so manually selecting...