Hi

Any and all help gratefully recieved!

I have a number of sheets in my excel doc that share a comment format (for various reasons they can not be created in one tab). For simplicity lets say 'task', 'status number', and 'text'.

I would like to be able to create a pivot table on a summary sheet which draws on information from all the backing sheets and can filter this. Essentially creating a table of the tasks from all the sheets and displaying this along with the status number and text, whilst also being able to filter the table to only show tasks with a specific status number.

Initially I have been playing with using a pivot table with multiple consolidation ranges. However, a couple of problems I am encountering;
- The pivot table automatically filters by page, but I would also like to be able to filter by one category which comes under the column heading (the status number),
- I would like to pull through text under the column headings not just numbers.

Any ideas that might work? The filter is the biggest issue, I can live without the text if need be.

Thanks