What happened when you tried the macro from Ron de Bruin's web site?

http://www.rondebruin.nl/copy2.htm

Khoshravan wrote:
I have same set of data for 50 runs of a program, each stored in a sheet. so
I have 50 sheets naming sheet1 to sheet50. Column headings are same for all.
I have to consolidate them into one sheet. Instead of going over 50 sheets to
add them in consolidation window, is it possible to perform it by MAcro to go
over 50sheets?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html