Consolidate sheets from MULTIPLE workbooks into ONE workbook

[share_knowledge]

I'd like to know if there is such a quick way in Excel that allows me to consolidate multiple workbooks, which contains two sheets in each, into one large workbook. Let's say i have 10 workbooks with the same format on each Sheet1. Now i'd like to consolidate these sheets into one workbook where it will show 10 of Sheet1 in there PLUS one more sheet that will sum up all the numbers.

I tried the consolidation function but it added up all the numbers then turn the cell into VALUE only. I'd like to know if there is such a way that will help us back track the linkage of these numbers. For instant,

='174001300'!D88+'174001301'!D88+'174001302'!D88 (then give total)

rather than just give me a sum of $100 in value.

Thanks in advance for any suggestions..

 

[ravishankar]

Hi
How many rows and columns of data you have on each sheet?
Ravi