I have a basic database where each tab is divided by years (columns) and months (rows). I have several of these files and each file has numerous tabs. i have created a coversheet within the file to "sum" all of the tabs.

When i create the formula for the coversheets first cell i try to drag it to all the other cells. however, some of the cells change and others do not. it is alot of manual work to type in the complete formula referencing all the other cells in all the other tabs. is there some kind of protection that is not letting the cells update correctly or autoformatting?

all the "october 2001" E7 is every tab. "october 2002" is F7, "november 2001" is E8, etc.... When i drag the formula on the coversheet, some of the references move and others don't.