Use the following function: =CONCATENATE(Sheet1!A1,Sheet2!A1,Sheet3!A1)
The concatenate will be in your Sheet 4.
If you have 4 sheets - the easiest way is on the MENU Bar - just click
on WINDOW 4 times and then select WINDOW - ARRANGE - HORIZONTAL


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=512905