I have a spreadsheet with several pages inside. Several of the pages are named after the month of the year, and obviously only January has relevant data so far.
I want some graphs on another sheet to get info from tables on the month sheets.
So, for example, I had a cell adding up the same cell in each month.
=sum(January!$L$5)
=sum(January!$L$5+February!$L$5)

etc.

I would like to just drag down these tables and autofill them as more months are filled with data, but excel doesn't like that.
Is there a way to do this?