If I am guessing what you are after correctly, you will have to paste
link to the original data.

If you select all the sheets that you wish the column to show on you
should only need to do this once.
HTH
Hywel


--
Hywel
------------------------------------------------------------------------
Hywel's Profile: http://www.excelforum.com/member.php...o&userid=14824
View this thread: http://www.excelforum.com/showthread...hreadid=488766