Yes, but we need some logic to determine which column to copy. Is it always the last (right-most column)? Which row can we look at and try to determine where the last column exists?
That is why I was asking for more specific details. We need to know the specific layout of the spreadsheet you are trying to copy from, and where the new data will be showing up.