Referencing variable sheet names in formulas?

I have a few pages with ranges of data formatted identically:

Each row and column is a named range based on the left/top.

NAME...|DATA1...|DATA2...|DATA3...|DATA4...|
Joe.......|Hat........|Blue.......|Candle..|Uruguay.|
Susie....|Cartoon..|Bumpy...|Alligator|Neptune.|
Ozzie....|Guitar....|Toenail...|Plaster..|Subway..|

(much more extensive than this -- many columns with various names and sub-ranges)

On another page I would like to create a full page report crunching the data on any one individual.

I know how to enter a formula to find individual points of data:

=Page1!Susie Page1!Data2

But how can I make the worksheet and name variable, rather than hard-coded? In other words, I would like two dropdown lists at the top of the page (I already know how to make the dropdown lists):

A1 = Dropdown list of Worksheet Names
B1 = Dropdown list of Person names

Then I would like to substitute the selected values into all formulas on that page, so:

=Page1!Susie Page1!Data2

would become:

=[PageReferencedInA1]![NameReferencedInB1] [PageReferencedinA1]![Data2]

I'm sure this is simple matter but I can't seem to get it... Any help would be appreciated.


[EDIT: a little searching points me in the direction of the INDIRECT function, but I'm still unclear as to its use]

Thanks

Deleted - intended to start new thread