Try this:

A1 = Word

=INDIRECT("'"&A1&"'!H5")

Note that H5 becomes an absolute reference.

--
Biff
Microsoft Excel MVP


"Huggy" wrote in message
...
Is it possible to reference another worksheet by entering the name of that
worksheet in an input cell within the current worksheet and referencing
this
cell within a function in the current worksheet.

example: current sheet name "Convert" cell C11 required to be = to cell H5
on another worksheet named either "word" or "report". The typical function
would be "=Word!H5" or "=Report!H5"

How do I make the "Word!" part of the above function a variable?