I understand the difficulty of so many sheets as the data sources but there
is no way around it. There is a lot of information entered on each daily page
(300 rows, column A-AV)and I need to be able to just pull those lists out. I
was originally leaning towards a sheet by sheet filter but it is not
practical for my needs. I'm going to try what Debra said and see it that
works. **keeping fingers crossed**

"Biff" wrote:

Lots of wisdom offered to you by some top notch folks!

My 2 cents:

I hate pivot tables. Can a pivot table have 31 sheets as the source?

Filters are OK but are not dynamic. Using a filter would require you to
repeat the proccess 31 times. No joy!

If you are intent on the layout of the file structure then formulas could be
used for this but the output would not be exactly as you expect. You would
need to extract the desired data from each of the 31 sheets to it's own
location and because the amount of data extracted from each sheet will vary
there will be empty rows between data sets.

Biff

"Excel Dummy" <Excel wrote in message
...
I have made a 33 page spreadsheet. One main for totals, 31 for daily data,
and a blank final page. I want to filter some data (first names, last,
customer account number from the daily pages to list on the final page
only
if they made a purchase of a specific item. In other words, if all
conditions
were met (all 4 columns were used) it would be sorted to the final page.
Each
of the daily ones have 40 plus possible entries. I am looking specifically
to
create an independant list on the last page if those particular 4 columns
have data. Anyone have a suggestion?