I have a file with 50-odd worksheets (each one is named after a person's name). I have a list of these names.

Is it possible to easily set up a formula to look for the worksheet with the person's name then return a cell's value from that worksheet?

So I already have a list of worksheet names in column A, and I want to use a formula in column B (for example, I want B2 to look for the worksheet named in A2 and return value C2 from that worksheet).