Using Reports / Dashboards for Analytics Recaps?

Hey there!

I'm currently tracking our sales analytics using a smartsheet.

Column A lists all of my metrics and then i create a column for each week. As the weeks progress, i fill in the rows with sales data.

I'd like to create a Dashboard that shows me the data from the last column (most recent week ending) on this smartsheet but I'm not sure how to pull that data into a report to display on my dashboard. 

Appreciate any help you can offer!

Thank you!