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.