Excel 2007 : Copy guests to designated table (ie Weddling guest list to table seating)

I have master guest list (counting up acceptances/refusals etc). I wish to tag names that have accepted and move them to another sheet into a designated list (the table plan). Eg Mr and Mrs Smith accept and I wish to place them on table A; Mr and Mrs Jones accept and I wish them to sit at table F. Can anyone help this novice please?