How to access different worksheets to do calculations. Yet another awesome time saving trick for me. End of the month reports may never be easier.
=SUM(WorkSheetName!M14:M26)
And yes, I know I must be the last person on earth to know this and I happily accept that fact.