Multiple table consolidation is effective option provided for a PIVOT.
There are certain condition to perform this otherwise you are done.
1. Make sure the layout and columns are smiliar across the woksheets and then add the ranges you want to add, and then you have the table ready.
Data --> PIVOT --> Multiple consolidation ranges --> Create a single page field, for me --> and add the ranges --> and FINISH
I hope I have understood your need correctly..