hi

I have created a quotes spread sheet for hire of equipment, I have 3 individual worksheets for 3 separate peoples quotes, which include date, time, customer, description, and booked date, the 3 main worksheets, are 'currently on hire, off-hired, and sales, i want to create a drop down box at the end of each row of information, I need the dropdown box to remove the data from the individual worksheets and move it to the main worksheets chosen in the dropdown box.