Creating a simple workbook in 2007

Giganews Newsgroups
Subject: Creating a simple workbook in 2007
Posted by:  nip (gbrea…
Date: Tue, 22 Jul 2008

Wanting to create a simple workbook to record the inventory of items.
1st worksheet name In
2nd worksheet name out
3rd worksheet name shelf

On #1 the item would be entered when it arrives and then show on #3
When the item is sent out it would be entered in worksheet #2 and
again be reflected in total on #3

Is this maybe something that can be done using forms for the in and
out items so others can enter information in a form and have the
totals show on #3?

Link to a tutorial on this would assist greatly TIA