Returning data from the same formula across multiple sheets

[MattBould]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a summary sheet that copies data from several specific cells on another sheet in the same workbook. I want to replicate the way my summary sheet gets that information but change the sheet it's getting the data from without having to change the sheet name for each and every target cell.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a summary sheet that copies data from several specific cells on another
sheet in the same workbook. I want to replicate the way my summary sheet gets
that information but change the sheet it's getting the data from without
having to change the sheet name for each and every target cell.

Use the INDIRECT function. I can't help any more until I get some specifics
of what the sheet names are and where the data is, and what you are trying
to do.