Do your sheet names follow some kind of sequential naming pattern? Like
this:

Week1, Week2, Week3

June 2009, July 2009, August 2009

--
Biff
Microsoft Excel MVP


"j.ruderman" wrote in message
...
I have a workbook containing 14 sheets all structured the same. Cells
E8:E39
may contain the text "PS Rep". When that text appears I need to extract
the
text from the adjacent Column F8:F39. I'm tring to do this in a seperate
sheet, for the entire workbook, in one column without spaces.

Thanks