Find and Select, Copy and Paste.

Thanks for the reply Marvin but I don't think that is exactly what I'm looking for. I've attached a screenshot of the workbook and search. What I want to be able to do is select and copy listings from the search results box and then paste them into another worksheet. I need to do every listing in one hit but unfortunately I can't select listings from more than one worksheet at a time. I'm not much good with code so the link you forwarded was fairly confusing to me.