I'm trying to write a formula that will take the data from Sheet 2 of my weekly dashboard and place it in the appropriate cells in Sheet 1. This would be easy but the tricky part is that every week I add a new column on Sheet 2 so I really need a formula in Sheet 1 that looks for the last column in Sheet 2 to pull through the data.

I'm having problems uploading to the forum so here's the example file:

http://goo.gl/kFtkl