I have about 100 worksheets with 4 columns and 20 rows. I want to consolidate all the info into one “Totals” worksheet. I start out at the Totals worksheet, Data + Consolidate, then click the button to take me to the first worksheet, select the cells, back to the consolidate box, click add and then have to go back to each worksheet and Add. Is there a way I can type in a range? I’ve tried: ‘A&P:ck benton’!$C$4:$G$4, but it tells me that it cannot open consolidation source file ‘ck benton’ (or whatever last file name I give) and does not consolidate. I hate to go through 100 worksheets. Any ideas?
