I'm creating a workbook that contains a "Front Page" worksheet, in which the
user inputs tank numbers, and then the worksheet returns specific information
about the tanks specified. For instance, some tanks are cylindrical, and
have a specific and constant volume/inch of depth, where as others are less
conveniently shaped, and instead have specific calibration tables which
provide the volumes at quantized depth levels.

I've created individual worksheets for each of these calibration tables,
with names like "Table 8", "Table 13", etc. What I want is for a user to be
able to input in a cell the tank number, have the workbook check in a
reference worksheet (which contains either the volume/level constant or the
name of the correct calibration table for each tank), and then if ISNUMBER is
false for the cell containing that information, use the contents of the cell
(which will be the appropriate table name) to refer to the actual worksheet
containing that table.

Example: User inputs T-85 (from drop-down menu, to ensure that the user
input actually exists), and a depth of 5 inches. In the volume output cell,
IF() statement checks the cell in the reference worksheet corresponding to
T-85's volume per depth constant/table reference, finds the text "Table 908",
and then goes to the worksheet entitled "Table 908" and retrieves the volume
at 5 inches. I know how to do everything except for using the cell contents
"Table 908" to actually refer to the worksheet named the same thing as the
cell contents.

NOTE: Above, any time I say table, I'm not actually refering to a literal
Excel table, just an aggregation of related and corresponding data.