Consolidating

[dmay1102]

Hey,
I'm looking to combine some workbooks. I have 30 one sheet workbooks, and I am trying to put the 30 sheets into one workbook. I was wondering if there is a way (macros or whatever) to have them linked up, so I can enter a number into one workbook and it automatically updates the other workbook. Thanks.

[olasa]

Here is a add-in that might do the job.
http://www.rondebruin.nl/merge.htm
Ron de Bruin is know to have good solutions
HTH
Ola