Copy formula but change sheet reference

[guamlenahans]

I have a workbook with a tab for each month. I want to make a summary sheet that will display the totals for each month. For example, I want cell A60 from each month sheets to display on the summary tab. Is there a quick way to do this? If I put in the summary cell A2 ='Sep 2015'!A60, how can I drag this to the next have cell A3 be ='Oct 2015'!A60? Do i have to manually type or is there a drop a drag shortcut?

Thansk

Rob

 

[Eric W]

You could create a list of your sheets, then use INDIRECT:

Book2
	A	B	C
1			Sheet1
2	5		Sheet2
3	6		Sheet3
4	7
5
Sheet9

Cell Formulas
Range	Formula
A2:A4	A2	=INDIRECT("'"&C1&"'!A60")