Your reply to Jay really helped me out, but I have an 'add on' to his
original question:
How can I use the INDIRECT formula to return the sum of specific cells in a
data worksheet. My summary worksheet has a cell that requires the sum of the
same 4 cells in each corresponding data worksheet. Any tips on modifying to
make it work?

Thanks much,
M. Moncrief

"CLR" wrote:

As an Example.....assume your data goes in columns B.....K
in cell A1 enter a sheet name
In B1 put this
=INDIRECT($A1&"!a1")
in C1 put this
=INDIRECT($A1&"!B1")...etc etc to get all 10 cells across Row 1
then in A2 put a new sheet name, and just copy and paste all 10 formulas
down to row 2

hth
Vaya con Dios,
Chuck, CABGx3


"Jay L" Jay wrote in message
...
I have one summary worksheet and approximately 45 data worksheets. Each
row
on the summary page needs 8 - 10 cells from each data worksheet. The data
worksheets are identical in format. I add about 4 new data worksheets a
month.

I am tired of the tedious formula entry for each new worksheet, and would
like to have a way where i can enter the name of the new worksheet on the
summary page and all of the formulas on that row use the entered text name
to
reference the appropriate worksheet and cell.

Alas -- I have been unable to easily do this. I am still a relatively
junior excel user. Any ideas?