Consolidating data from multiple workbooks into a separate workbook

Originally Posted by Naveed Raza

can you please attached sample excel workbook, its make very easy to resolve ur query

I've attached a copy of the spreadsheets just as an example of what I'm trying to achieve.

Consolidated.xlsx
Product_A_August_2013.xlsx
Product_B_August_2013.xlsx
Product_C_August_2013.xlsx

I would like the consolidated spreadsheet to update based on the Product spreadsheet.

My only concern is how I would manage this spreadsheet as the months go on, because I would have to include, September, October, November, etc in this spreadsheet.