Is it possible to create a pivot table from mutiple worksheets in one file? The total data is too large for one excel worksheet. If it can be done, how?

Marian