I'm trying to convert something that has always been done by hand...but I'm not sure if I can do it. I need to pick some brains here to see if there's a way to do it.

Here's what happens right now.
Money comes in by check and cash.
Money is recorded on one sheet, the names of the people giving the money is entered, along with the amount, and if it's cash or check.
On a second sheet - a deposit tracking sheet - the money is broken down into all that is received - tens, fives, ones, checks. Basically this is just a numbers check to ensure everything balances.

This happens every week, and all this has been done by hand. Now I want to translate this into Excel to make it easier.

Here's what I want to do:
Money comes in by check and cash.
Money is recorded on a sheet (let's call it SHEET1) in a workbook, with the names of the people along with the amount and cash or check.
The data from this input will be filtered into another sheet (let's call it FORM A), and this sheet is printed out so that it looks like the second sheet (above) that used to be handwritten.

Formulas and data filtering I'm not concerned about at this point. That's the easy part. The hard part is this:
I want to be able to enter the data in the workbook not just on SHEET1, but also SHEET2, SHEET3 and so on. I need this info to be saved in the sheets. HOWEVER, I want to be able to use FORM A to be the sole output. FORM A will be printed each time (due to the need for sigs on it), so it doesn't have to be saved electronically.

Am I making sense? Basically, I have a workbook with SHEET1, SHEET2, SHEET3 and FORM A. On Week 1, I enter data into SHEET1 and print the output from FORM A. On Week 2, I enter data into SHEET2, and output again from FORM A. Week 3, SHEET3 and FORM A.

Is this possible, or can I do it with all the input sheets being in one workbook, and the form being in it's own workbook?