Yes

--
Don Guillett
SalesAid Software

"HJ" wrote in message
...
Or am I thinking of Indirect?

"HJ" wrote:

I have a workbook with 30 tabs, all of which have the same format. I'm
trying to create a summary worksheet that references the same cells in
all 30
worksheets. I don't want to do the ='Sheet1' then =Sheet2 etc. for all
30
tabs and I know there is an easier way but I can't remember how. I seem
to
recall Index but I don't completely understand how it works. Any
suggestions?