MikeDH wrote...
I'm looking for a way to refer the Indirect(Address(... functions to yield a
result from a cell in a different page of my spreadsheet. Any help?

Very little help possible since you haven't provided sufficient
details. If you had worksheet names in B2:D2 and wanted the values of
cell X99 for each of these worksheets, you'd be better off not using
ADDRESS but

=INDIRECT("'"&B2&"'!X99")

Even if you have row and column indices, you're be better off using

=INDIRECT("'"&B2&"!R"&99&"C"&24,0)

If you mean something other than this, it's up to you to provide the
necessary details.