Two spreadsheets, filling data from one to the other.
 

I'm trying to setup a daily report, that when filled, fills a monthly spread sheet in the second tab. In other words. Todays sales= A1 when i fill in A1 it fills it the 9th cell on my second spread sheet, because today is the 9th. The next day it fills in the 10th, etc.