Sorry if this sounds silly, but I'm new to excel.

Is it possible to have sheet1 in excel 2003 work as a data entry form, IE:

Date

Deposit
Accounts payable
Accounts receivable
Tax

And Sheet2 set up to hold the data per day as a list, IE:

Date|Deposit|Accounts payable|Accounts receivable|Tax
#
#
#

Thanks