Data transfer between two sheets based on condition

Hi,

I work for a sales team and we have a bit of a problem automating a process for copying data from one sheet to another based on phone numbers.As of now this process is manual and my team spend hours doing this manually.

We have weekly reports coming to us as shown in 'Week 34.xls' (copy of the sheets attached)spreadsheet,and we manually transfer data from Coloumn E and Coloumn AC into the sheet 'DM Tracker.xls',based on matching Telephone numbers in coloumn B of 'Week 34.xls' spreadsheet and coloumn B of 'DM Tracker'.

I was wondering if there is a way to automate this process? This will definitely save us hours of work,especially on those 'Dreadful Mondays'!

Any help on this will be very much appreciated..

Thanks,
Andy