As you did not specify otherwise I presume there is something like Sheet
1 has rows 1 to 250, sheet 2 has rows 1 to 500, and sheet 3 has rows 1
to 250 etc.

To join those you would highlight and Copy the rows in sheet 2, then,
then in sheet 1 click in cell A251 and Paste, then repeat the process
for sheet three into cell A751 etc.

If you wish to match-and-merge data on the same rows from columns in
another sheet that could be more difficult.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390749