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
------------------------------------------------------------------------
Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822
View this thread: http://www.excelforum.com/showthread...hreadid=504865