I'm looking to combine workbooks below into a master workbook if the last text in the workbook file name is the same.

workbook - 2011 IA Activities - pool
workbook - 2011 IA Sales - pool

workbook - 2011 IA Activities - tent
workbook - 2011 IA Sales - tent