I have a workbook with several tables that are all of the same format. I want to combine all these tables into one big table and use that table for pivot table analysis.

So far, all the examples I can find on the web is that powerpivot works by importing data only from external sources.

I think that I can make the workbook an "external" source, but then when I send the workbook to my co-worker, this "external source" will break because he will save it to a different directory.

Is it possible to use powerpivot to combine tables from the same workbook and if so, is there a pointer to where this is explained?