consolidating worksheets

[shadowplay]

Hi to all excel experts out there...

I am trying to find a way to consolidate data from several workbooks into one however the data must come from the separate workbooks and has to be updated everytime the consolidated workbook is opened.
There is a nice twist to this one aswell... the data that is required for consolidation is text.

let me know if you need more info...would be great if you could supply the soloution...

 

[shadowplay]

dont worry already found the soloution

 

[ravishankar]

Hi
why don't you share the solution you found, so that others with similar problems may use it
Ravi

 

[shadowplay]

if anyone want to know the answer then let me know...