Guess I dont quite understand your method. I have 1 workbook with 28, 29,
30, or 31 worksheets depending on the month. Each worksheet has a varying
number of rows, but the data is always in ColA & ColB in the same format.
Using the same Name>Define didnt work on the worksheets in the same
workbook.
Maybe this will help...I recorded a test macro of your original
Data>Consolidation suggestion that works great. Just was looking for a more
automated way of doing it.

Sub Consolidate()
'
Range("A1").Select '<<<<<<<<<<On my Summary sheet.
Selection.Consolidate Sources:=Array( _
"'E:\Directory\My Documents\[TabTest.xls]1'!R1C1:R12C2", _
"'E:\Directory\My Documents\[TabTest.xls]2'!R1C1:R25C2", _
"'E:\Directory\My Documents\[TabTest.xls]3'!R1C1:R20C2", _
"'E:\Directory\My Documents\[TabTest.xls]4'!R1C1:R14C2", _
"'E:\Directory\My Documents\[TabTest.xls]5'!R1C1:R21C2", _
"'E:\Directory\My Documents\[TabTest.xls]6'!R1C1:R12C2", _
"'E:\Directory\My Documents\[TabTest.xls]7'!R1C1:R9C2"), Function _
:=xlSum, TopRow:=False, LeftColumn:=True, CreateLinks:=False
End Sub

TIA,
Don

"Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
news:57596663-83EF-464F-9508-B439DEE2AC30@microsoft.com...
> I believe that, through judicious use of range names, you won't need to
> re-adjust the ranges to be consolidated. Since you'd be referencing Named
> Ranges, and not cell references, the Consolidation would pick up the
correct
> information.
>
> Example:
> The range A1:C50 on Sheet1 of each workbook1 could be named rngMthData.
> The range A1:C73 on Sheet1 of each workbook2 could be named rngMthData.
>
> The next month, set each rngMthData range to refer to the appropriate
ranges.
>
> Does that give you something to work with?
> --
> Regards,
> Ron
>