Multiple worksheets & duplicating formula

[Jackie]

I have 35 worksheets; one w/s for each volunteer Each w/s has the exact
document to capture the number of hours a volunteers works and the type of
service they perform (ex: office work, patient care). I created a work sheet
listing the name of each vol (running vertically) and a row of cells
(horizontially) to capture the total for each month for each vol.

How do I change the formula to between w/s without having to do the = sign
for each cell from all worksheets?

I'm using Excel 2003

Thank you for saving my mind from exploding!
Jackie

 

[CurlyDave]

Experiment with the Indirect function, you will be able to reference
another worksheet by what ever worksheet name in in a cell

Here is a very simple Sample
http://sites.google.com/site/davese...gIndirectToReferenceSheets.xls?attredirects=0

More on Indirect Functions can be found here...
http://www.contextures.com/xlFunctions05.html#RefSheet

 

[Khoshravan]

If the structure of your sheets are same (the columns, rows may have
different size), another solution for getting a summary sheet of all vol. is
to use consolidation under data menu. Consolidate will summarize the data
from different sources to one.

 

[Jackie]

You are my HERO. Thank you!
Jackie

 

[Jackie]

Thank You for saving my brain from emploding!
Jackie

 

[Jackie]

All my worksheets; each tab having the individual name of a volunteer has the
exact same format and cell reference. I looked at the data - consolidate
option and I would greatly appreciate it if you could provide a simple sample
of how to feed all the information from the 35 worksheets to the single
worksheet that captures the total hours for each month. The INDIRECT
formula has saved me many hours...not having to enter "=" and clicking on
each worksheets specific cell I want information from. I'd love to learn of
another option.

Thank you so much for your interest and time.

Jackie

 

[CurlyDave]

You are my HERO.  Thank you!  
Jackie

It's hard to describe, not knowing what the layout of your worksheet
is. You can loop through the sheets with VBA to get the sheet names
and values from all the other sheets.
Check out this example, enable macros when you open the Workbook.

http://sites.google.com/site/davese...GetValueFromEachSheetMacro.xls?attredirects=0