I have created two worksheets:
1) Auction Items
Item# Table# Location# ItemDescription WinBid are the headers of the data.
2) Bidders
Bidder# FirstName LastName

I would like to be able to create a macro or something that will allow me to
enter the item#, bidder# and winning bid price and have a sheet filled with.

ie.
Item# 2 (Handcrafted Table)
Bidder# 12 (John Doe)
Winning Bid $250

Can excel pull from two sheets and created another sheet with all the final
details?
I am a little new to excel (version 2000) it is the only tool/application
available to us at this time. If anyone can point me in the right direction
it will be a great help.
Thanks
dD