indexing or combining the data from work books

[Guest]

is there any other way that i can combined all the data from others work book into another workbook... we have a few remote branches and i put ordering workbook to every branch for them to order then send to our main office. The problem is we are not giving to them the tittles or discreption. What i want is, In my summarry workbook what is the command or the formula that can get all theysame tittles or discreption from the other workbooks and combined it into one and add the quantity of the orders.

Thanks a lot ...... please help me.........

 

[Frank Kabel]

Hi
not really sure how your workbooks are designed. You may
provide some more details. e.g. some example data as plain
text (no attachment please) and an example of your desired
result based on these example data

-----Original Message-----
is there any other way that i can combined all the data

from others work book into another workbook... we have a
few remote branches and i put ordering workbook to every
branch for them to order then send to our main office. The
problem is we are not giving to them the tittles or
discreption. What i want is, In my summarry workbook what
is the command or the formula that can get all theysame
tittles or discreption from the other workbooks and
combined it into one and add the quantity of the orders.