Combining Data From Multiple Worksheets into Master

I am using Excel 2007 and trying to combine data from regional worksheets into a master worksheet. I've found several VBA options, but none seem to work for my specific situation. I'm also open to a non-VBA solution if one exists. What I'd like to happen is for the data on the attached worksheets 1, 2, and 3 to compile on a 4th worksheet. As the example shows, the worksheets will have different numbers of rows, and the number of rows will change over time. I've tried creating dynamic named ranges using the formula:

=OFFSET('Branch 1'!$A$28,0,0,MATCH(1E+306,'Branch 1'!$A:$A,1),11)

The range seems to function, but I still can't figure out how to compile the various ranges into a single sheet. Thanks in advance for any suggestions.