I would like to use the value of a cell, in this case a stock ticker, to
refer to another worksheet that is named identically. For instance, I have a
cell value UPS and a worksheet named 'UPS', I would like to pull a value, say
D21, out of UPS! without hard-coding UPS! into my formula.

I'd eventually like it to reference a column of different tickers and pull
out of an equal number of different worksheets, all named the values of the
tickers. I think it should be a simple syntax thing, something like
='value(B1)'!D$21$, if my reference is in cell B1. Is this possible?