Macro updating a new column each day
 

I have a macro that run's daily and gives me the output I want, However I
would like for it to autopopulate the correct line of information.
For example.
The updated numbers are coming from a pivot table are the raw numbers. I am
copying and pasting them to the correct column and day. So tommorrow I will
post 8/1 infomation. What would be the code to get it auto copy and paste to
the correct day?

7/30 7/31 8/1
Data 1 123 111
Data 2 456 222
Data 3 789 333