What I want to do is have the 2nd tab get information from the first tab automatically and dynamically.

At the moment I've managed to get the information from Column P but since the information is added weekly if I add information for the next week it will still reflect the information in column P instead of the most recent Column.

Does anyone know how to make this update automatically from the most recent

Example:
http://www.roadbullettransport.com.au/report.xls

Note: I have highlighted the column in blue which I'm talking about.

Thanks in advance.