Flatten a Crosstable

Hi

I want a neat method to flatten a crosstable. I have seen some example that you can do by creating a pivottable from multiple sheet. I

http://www.youtube.com/watch?v=pUXJLzqlEPk

However I have a some problem when i create a pivot table from multiple sheet to flatten a crosstable. The output of data is placed on new sheet. It there a way so the output of data will be on the same sheet.