pull data from multiple sheets into summary sheet

ok so this isnt a new thread, but i posted the exact same post almost a week ago with exactly the same thread title and had no no hits and no replies, in fact, apart from in "my posts" i didnt even see it appear in the forum anywhere.

so here it is again

I have a workbook with mutilple worksheets - data input worksheets for each month - and then a summary worksheet. i need to be able to enter a value (lets call it AAA) in a cell C4 (or it could be an input box) and search for all instances of AAA in all the worksheets

Then i need all info in the row AAA was found, to be copied to my summary sheet, starting at C4. there may be more than 1 entry for AAA on each sheet, or there may be none.

Also, I would like the ability to retain the data that was left from the previous search if i choose (in other words, the option to delete the previous search or keep it)

if a sample sheet is needed, i can provide that, but im pretty sure this is a standard VBA template that some1 like shg or daddylonglegs or martin has in their back pocket lol

previous post was at...

http://www.excelforum.com/excel-prog...ary-sheet.html

Do you have a sample file that you can upload?

it was actually to help some1 else who posted here, but i thing they went with Pete's suggestion...thx Pete

However, I often see posts on here for this sort of requirement, and was wondering if there was some sort of standard VBA that could be applied to a situation like this.