I have the ID on one sheet and I need a list of what locations that employee has worked in before. I would like to have the information on one sheet instead of looking it up for each ID each time I need it.
Ok use CNTL-F then if its for information purposes. Otherwise you need VBA. If you need VBA you need to be a lot more specific on what the data looks like and what you want the end result to look like.
There was a post that said you could use this formula: =VLOOKUP(C1,INDIRECT("Sheet"&MATCH(TRUE,COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT("1:10"))&"!A2:A100"),B1)>0,0)&"!A2:B100"),2,0)
I know it said to use a range for the sheets that you are searching and I did but it still would not return a list of the sheet and cell reference.