How to copy a cell range based on a condition

Hi all.
I have posted this somewhere else but i had no luck, (most likely my own fault).
What i need to do to search through several worksheets and look for the word 'Case Closed' in column G on rows 2 - 88 and when this is found then i need to copy the contents of cells A to E of the same row to a summary page.

Please help this is driving me nuts.

Another option:

Please Login or Register  to view this content.

Hi Guys,
Thank you both i will try both ways out shortly.

Hi.
I thank you both for your answers and both way's do work,(and work well).

However with cell protection and work sheet sharing that is turned on in differant work books neither way works for all. (i did fear this)

So i have try another approach which is seems to have to be to have a separate work book open and have the macro run from there, and have the data copied from closed work books into the separate open work book.

Any and all ideas and suggestion will be greatly appreiciated.