Updating worksheets with new data in another worksheet

Hi

I have a workbook with several worksheets. One of the worksheets contains a summary of all the other worksheets.

The main worksheets are updated on a monthly basis with a new column of data and the previous columns remaining the same.

What is the best way to automatically update the summary sheet with the new data each month.

EG

Worksheet 1 add new column of data in column 7
Data from worksheet 1 column 7 appears in new column 7 of summary worksheet

Thanks

CC