Custom Reporting Across Sheets

[joey]

I am using excel 2007.

I'd like to be able to make X number of sheets and create a cumulative log of a certain filtered range on a summary sheet.

For example:

I have multiple sheets of identical setup, but different transactions, let's say the range I want to summarize is as follows:

Transaction A
Name Amount Paid
Joe $100 True
Tom $200 False
Jim $50 False

(new sheet)
Transaction B...
Joe $100 True
Tom $10 False
Jim $0 True
....

Now I want a summary sheet that has the transaction name listed as such:

Trans. Name Amount Paid
A Joe $100 True
A Tom ...
A Jim
B Joe
B Tom
B Jim

I've tried pivot table, but can not seem to collect data from multiple sheets.
Any suggestions?

 

[Don Guillett]

I am using excel 2007.



I'd like to be able to make X number of sheets and create a cumulative log of a certain filtered range on a summary sheet.



For example:



I have multiple sheets of identical setup, but different transactions, let's say the range I want to summarize is as follows:



Transaction A

Name Amount Paid

Joe $100 True

Tom $200 False

Jim $50 False



(new sheet)

Transaction B...

Joe $100 True

Tom $10 False

Jim $0 True

...



Now I want a summary sheet that has the transaction name listed as such:



Trans. Name Amount Paid

A Joe $100 True

A Tom ...

A Jim

B Joe

B Tom

B Jim



I've tried pivot table, but can not seem to collect data from multiple sheets.

Any suggestions?

Why not just have ONE sheet with all and filter ???