combining information from several sheets into one sheet

[bhuff_1970]

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?

 

[Ron de Bruin]

Hi ?

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