Numbers formula question

I've got a numbers file for work that keeps track of all my sales. What I would like to do is have 5 sheets in a file. 1 for year to date totals and 1 for each quarter of the year. I want to enter the data into the year to date sheet and have it automatically update the appropriate quarterly sheet. I can't quite figure out how to do this. Also, I would like to do bar graphs that update when I enter new data in to show how I'm doing each quarter. Can anybody help me with this?