Sure,

I've seen a setup like this before. I have a spreadsheet that I use to calculate daily sales for a retail store. In the past, the guy that was doing it was actually printing the sheet and doing all the calculations manually. I've added the formulas to automate it. Anyway, also in the past, at the end of the month, the guy would take all of the sheets and manually type in all of the info into a monthly spreadsheet. I'm wondering how to make it so that, each day, after the daily sheet is filled out and then saved (with a unique filename) it could be used to populate a column on the monthly spreadsheet automatically. Make sense?