How to auto fill cells with information from database in another sheet

Hi,

Im having trouble figuring out how to do some excel formatting to make my life a little easier. I actually have two questions. First, I have a database of info in the format as follows:

A B C D E
1 v w x y z
2 v w x y z
3 v w x y z

I have created an order form in another sheet and it requires the five pieces of data in each row. I would like to set the order form up so that I can manually enter v and then the remaining four pieces of data will automatically populate in the next four cells in the same row. Any help with this would be greatly appreciated!

I also am interested in a thread I read about an excel 2002 Template Wizard with data tracking. It is exactly what I have been looking for. Is it possible to create a form in excel 2010 and once i fill in the data, from say an order, it will automatically send the data to a database in another sheet and then somehow reset the order form back to blank?

Thanks
Jon