combining information from several sheets into one sheet
 

Right now what I am doing is copying information each time into the
different sheets, I'm sure there is a formula to make this process
easier. I want columns A - E from sheet 1, 2, 3, 5, 6 to go into
sheet 10. So Column A from Sheets 1,2,3,5,6 go into column A of Sheet
10 and so on and whenever I add to sheets 1, 2, 3, 5 and 6 the
information will automatically go into sheet 10. Is there a formula
that will work for this?

combining information from several sheets into one sheet
 

Hi ?

I have a code example on my site to do this
http://www.rondebruin.nl/copy2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ups.com...
Right now what I am doing is copying information each time into the
different sheets, I'm sure there is a formula to make this process
easier. I want columns A - E from sheet 1, 2, 3, 5, 6 to go into
sheet 10. So Column A from Sheets 1,2,3,5,6 go into column A of Sheet
10 and so on and whenever I add to sheets 1, 2, 3, 5 and 6 the
information will automatically go into sheet 10. Is there a formula
that will work for this?