I have what I think is or should be a relatively straightforward question.

I have a data sheet that is designed for a very small screen, i.e. an IPAQ.
From the various and voluminous amounts of data on this sheet I would like
to pull a "Report" in a new sheet, hence the "Report Sheet". I would like to
format the new sheet such that all I have to do in input a "Single
Reference" in a single cell on the "Report Sheet". This "Single Reference"
would point to the data sheet. The "Report Sheet", by way of some kind of
relative referencing to the "Single Reference", would then spontaneously
populate the entire report. My data sheet is organized such that I can
always use relative references to my "Single Reference". I hope I have
iterated this well enough so that someone will be able to assist me. Thanks!

An Example:

ReportSheet!:

Contents of cell A1:
=DataSheet!C14

Contents of cell A2 interpretation necessary:
=referenced location in cell A1, e.g. DataSheet!C14 Add one column to
this
location, e.g. DataSheet!D14 indicate value at DataSheet!D14

Contents of cell B5 interpretation necessary:
=referenced location in cell A1, e.g. DataSheet!C14 Add ten rows to this
location,
e.g. DataSheet!C24 indicate value at DataSheet!C24

Contents of cell F2 interpretation necessary:
=referenced location in cell A1, e.g. DataSheet!C14 Subtract two rows and
add one
column to this location, e.g. DataSheet!D12 indicate value at
DataSheet!D12

And so on.....


Your help is appreciated Thanks!

-Gary

P.S. I have played for hours with the following functions, to no avail:
INDIRECT, OFFSET, ADDRESS, CELL, and T. I believe that one or more of these
are involved in the solution, but cannot discern which.