Need much more detail in order to help with specifics.

Example of using indirect function with default sheetnames Sheet1, Sheet2
etc.

=INDIRECT("Sheet" & (ROW()) & "!E3")

Entered in summary sheet A1 and copied down to pull E3 from all sheets.


Gord Dibben MS Excel MVP


On Tue, 2 Jun 2009 15:33:01 -0700, CLGonline
wrote:

need assistance to build formula so i can use cell contents to create links
to other tabs within spreadsheet