Need cell to find data and extract from one sheet of 10 possible sheets

[JimmyHuss]

TestSheet.xlsx


In the "database" sheet, there'll be two cells. One "ext[ension]" and the other "hall". I need the extension cell to reference the other sheets with regards to the data in the "hall" cell. So if the individual is in G103, I need the formula to extract that information from the proper sheet.

In every instance the data being extracted is exactly 1 cell away from the "hall" information cell, if that makes sense, as you can see in the testsheet attached.

As always I appreciate the help I get here. You guys rock.