copying column information automatically into a second sheet, accounting for new rows

Question

This query is probably very simple but I am not experienced enough to adapt the macros I have seen here.

I have two worksheets, and I need to mirror several columns from one worksheet into another one at each start up, accounting for additions of rows that may have been made in the first worksheet and also showing these in the second.

I also need to be able to set a macro to scan a range of rows (the range may be expanded over time) to scan for the latest data contained within this range of rows and show this in a separate cell at the end of this row.

Please can you help!!