So I have a worksheet that has a main column of labels (apples, oranges, etc) and I add a new column every week with metrics for that week's data in that category. Then I display that week's data in a dashboard on another worksheet.

Can anyone help with with a formula to pull the metrics from the last column into my dashboard automatically without having to touch the dash?

Here's an example of what I want to do:

example.xlsxexample.xlsx