How to put a worksheet tab name in a cell?

[Skeep]

Does anyone know how to put a reference link or formula in a cell that has the worksheet tab names on it. The following is what I am trying to do:

work sheet 1 Total for all regions

cell a1 - name of worksheet 2 or the first region
cell b1 - name of worksheet 3 or the second region on so on

Please help..

[JE McGimpsey]

See

http://mcgimpsey.com/excel/formulae/cell_function.html

In article <[email protected]>,
Skeep <[email protected]> wrote:

> Does anyone know how to put a reference link or formula in a cell that
> has the worksheet tab names on it. The following is what I am trying to
> do:
>
> work sheet 1 Total for all regions
>
> cell a1 - name of worksheet 2 or the first region
> cell b1 - name of worksheet 3 or the second region on so on
>
> Please help..

[Skeep]

Thanks so much