Search Multiple Sheets of a Workbook & Copy the Results

mjk3001 Posts 1 Registration date Thursday June 4, 2015 Status Member Last seen June 4, 2015 - Jun 4, 2015 at 01:15 AM

So I have a problem and I can't seem to find a similar question asked before.

I have an excel workbook with 10 sheets.
Each sheet is regarding a different issue.
Details of that person are entered as a new row on the sheet that applies (as and when there is an issue). Name in A, Number in B, Day in C, Specific Details in D etc.

I need to be able to search the entire workbook (similar to Ctrl+F) but then have all the results copied, or marked to copy. As it stands at the moment the "results" from the search can be between 0 and 40.

Is there anything I can do (be it a macro or existing Excel function) to achieve this?

I hope this makes sense.

Thank you in advance.