To set the scene:
31 tabs, one for each day in a month. One tab that says "summary". Each
daily tab boils down call volume by hour. The Summary tab will gather that
data by day. Therefore, on the summary tab, I have the days of the month,
1-31, across the top, and the phone cubicles down the left side.
So,column 1 is titles, column 2 shows data from tab "1", and column 3 shows
data from tab "2".
My Problem: when I drag the column 2 formula across, I need it to
automatically change the tab protion of the reference to the next successive
tab.

Can it be done?