Joe
Based on your several posts, it seems that while the data is in 51 sheets,
you really need it consolidated into 1 list. I'm wondering if the real
problem is the data structure. Is it absolutely necessary to have over 50
identical tables distributed over as many sheets? I'm guessing that each
sheet pertains to a different category (week, dept., etc).

If that's true, wouldn't it make more sense to have ALL of the data in 1
sheet, with a column that contains the category? For example, Col_A could
contain Week01, Week02, etc.

With all of the data in one data list, extracting, filtering, and reporting
become much easier.

If there is a perceived need to keep the current structure, can you share it?
***********
Regards,
Ron

XL2002, WinXP


"Joe" wrote:

Hello

I have 52 sheets in the same workbook.

Sheet 51 is a summary sheet, sheets 1 - 50 are detail sheets.

I would like sheet 52 to be an analysis sheet.

In the top corner of sheet 52 I would like to be able to put a code
reference on and below it, it then lists all of the sheets that contain that
code and what value the codes has next to it.

What is the easiest way of doing this?

Thanks