Excel：使用VBA整合变量工作表

I have seen a lot of "consolidating" with VBA on the web, but mostly are copy and pasting from one sheet to another. I am trying to use excel's own consolidating tools, but in VBA. The thing is, the number of sheets can be from 3 to 100. So, it is not quite practical to choose the parameters one by one. Suppose each sheet has the same format, 3 columns. I would like to consolidate the last 2 columns (2 and 3). Each sheet has a specific naming convention, which is some_2015-??, where the last two are digits, in sequential manner (00~99). Consolidating function works admirably, just that needing to specify each range for each sheet is not practical.I have seen a lot of "consolidating" with VBA o