Macro to move data from 2 worksheets on to a summary worksheet

[recain]

Hello all,

I'm looking for some help on macro to combine information on 2 different worksheets to make a summary worksheet of totals.
I have one worksheet(sales data) that has accounts with sales information and our company info listed that I would need subtotaled by account and indicate which of our companys were included in those sales. I also have another sheet(route info) that I need to have the ship via information pulled for the corresponding account and then populated on the summary worksheet. I have included samples of all 3 workbooks that I am looking to combine. The totals one is how I would like it to come out in the end. Any help would be greatly appreciated.

thanks
eric