How do I set up my workbook to transfer information automatically from on
work to the next depending on what is inputted in one cell.

What I'm trying to do-
I have a set of rows with vertical information (contractor name, contact,
contact phone number, ect.) in a worksheet (Bid Information) and I want that
information to transfer to a new worksheet (Bids Sent) according to what I
insert in the column labeled sent, on the Bid Information worksheet. I want
to be able to put a "y" and have the information in that row sent to the next
worksheet labeled "Bids Sent" and from the "Bids Sent" worksheet have a
column labeled "Won/ Lost" and have the information in the rows with a "W"
sent to the "Won" worksheet and the rows with "L" sent to the "Lost"
worksheet.

Thanks for any help you can give me. I don't know where to start so looking
in the help book doesn't really help- so even giveing me a place to start in
the help book is great!

Thanks!!