Try this for a macro solution
http://www.rondebruin.nl/tips.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Chris" wrote in message om...
Hi there,

I would like to write a macro/formula to read certain information from
several excel worksheets and to write it into another worksheet.
I have no clue how to start so if anybody can help me or provide me
with some links where I can get information about that I would be very
happy.

Thanks

Christian