Column of Data to be copied and Continusle updated

On sheet1, copy the cells you want linked (e.g., E1:E30) then switch to sheet2 and position the cell marker in the first cell where you want the linked cells to start (e.g., B1). Click on Edit, Paste Special, Paste Link.

That works but it doesent seem to work if i add a new row into the column of data on sheet 1, any idea how to keep it updated with extra data added to the list too?

The only way I know is to either add the extra links as new data is added to the main worksheet, or to link the entire worksheet, including blank cells.

If this isnt possible to do is there any way in which i can create a macro or command control button to be able to select multipul columns and get them printed next to each other on the sheet?

This could be possible but is beyond my level of expertise. Perhaps someone else can help.