Merging multiple worksheets into one

[Guest]

Hi all,

I have one workbook with several worksheets, all of which
have the same exact layout and similar data. In the same
file, I also have what's called a 'Master sheet'. I
would like to basically merge all of the data from every
worksheet I have into this one Master sheet, creating
continuous rows of information.

Is this possible in Excel 2003?

Thanks for any help you can offer...
Joe

 

[Ron de Bruin]

Hi Joe

You can try this
http://www.rondebruin.nl/copy2.htm

 

[Guest]

WOW - this worked GREAT. The boss will be very happy.

Thank you,
Joe