Excel 2007 : How do I get sheet 1 cell M15 to automatically enter on to sheet 2 at cell C15?

[crash81]

I have on Sheet 1(May 2012)at the cell location M15 is a grand total from two or more cells on the sameline that I would like for it to automatically enter onto sheet 2(June 2012) at cell C15 to continue do this for the year from sheet to sheet as each month passes. Can you help me with this and maybe explain the code and Modules? I see all the month's in the veiw code but I fine that I am not familiar with this area. Please help? Thank you

[SCLai]

Is it possible just to put in your Sheet 'June 2012' Cell C15 this?
='May 2012'!M15

Subsequently in Sheet 'July 2012' Cell C15:
='June 2012'!M15

And so on...

Is this what you are looking for? Or were you looking for VBA or such to do this automatically for all the sheets?

SC

[crash81]

SCLai , Thank you, it does seem to be working. I didn't use the quotes around the sheet name (May 2012) before. Thank you so much for your help.

[SCLai]

Oh, the quotes are only necessary when your sheet name has one or more space in it.
E.g June 2012

If it doesnt have any space in it, then the quotes can be done without
E.g June2012

Please also do mark the thread as solved if all your questions has been answered, thank you!