Hi
I want to build a pivot table on database that is not centralize in one place.

every month the new data is insert in a new sheet (of course with the
same fields names)
But the wizard, refuse to build a pivot table from data that is not
concentrated in one place.
(My intention is not the option: "Multiple Consolidation Ranges".)

I have a feeling, that there is a way to circumvent this limitation.
I appreciate a solution to the problem that a long time bother me.
thank you.
Barak