Input Sheet, Output Form - Can I do it?

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?

You could do it as you described and have a cell in the FORM A sheet to select which sheet to get the data from.

Post an example workbook to show what your Sheet1, Sheet2 etc look like, as well as Form A.

It's late here, so I'll pick this up tomorrow if no-one else replies.

Pete

Hi,

I have use INDIRECT formula to get the data from require sheet.. Please see the attachment. Let us know if it works.

I think your example might work. Let me play around with it and apply it to my workbook and I'll let you know how it goes. Thanks!

So I've been working on this, and trying to understand the formula (which honestly, I don't), but it does work for what I'd like to do. Thanks so much! Hopefully I'll be able to "get it" in the future.