Hi,

You can use the following formula and copy down. A3:A13 has 2009 to 2019

=INDIRECT("'"&A3&"'!G34")

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Vic" wrote in message
...
Thank but thats not it. ok lets try to explain. 2009 tab is a running
expense
for the year. it configure column a date 1/1 thru 12/31. each month has 5
catogories from columns D-H and Columns M-Q each of these columns has a
monthly total. i have created a separate summary tab which separates these
columns and import the monthly totals. (='2009'!G34) i would like to copy
this summary tab in front of each year and only have the 2009 in the
formulas
change to ='2010'!G34,='2011'!G34 etc. can this be done without manual
entry
for each year?

"Pecoflyer" wrote:


Mike H;253207 Wrote:
Hi,

This assumes the first sheet is 2009 and the last 2019 and all the
other
sheet are between those 2 sheets

= SUM('2009:2019'!A1)

Mike

"Vic" wrote:

my workbook consist of 10 one year expense tabs 2009 thru 2019 and a
summary
tab.
i want the summary tab to tally the calender year expense as i copy
the
summary tab from year to year. Every year tab uses the exact same
cell from
year to year. the only difference is the the tab 2009, 2010, 2011,
etc

If you're not sure of your syntax select the cell were the formula
should be
Enter =sum(
Click the cell you want to sum
While pressing the shift key select the last tab you need.
Add the closing parenthesis
Done


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=70701