Copy values on certain date

I have a spreadsheet that gets its values from a datalink. The values change when the date is changed. I can only see the values on the day that date that is selected. Now I can copy those values manually, but is there a way to copy those values to another sheet automatically? I need to build a monthly report of all the data, not just the 1 day.

daily readings.xlsx

Ok, here it is without the data link sheet. But I think you'll get the idea. The data in columns B:I is updated when I change the date in cell A1. I want to copy and paste those values to the columns M:AY. This will allow me to see the months data all at once, without manually copying and pasting.
Thanks for looking

I guess I should clarify that I cannot just referance each cell, since when I change the date in A2 I lose all data except for the present date.

Anyone? Please Help ?!