Yes, that's what the "Multiple consolidation ranges" option at Step 1 of 4 in the PivotTable wizard is for. However, you need to understand that this feature is intended for the consolidation of 1 or 2-dimensional data tables with common row and/or column labels. The Consolidation feature existed long before PivotTables. I'd recommend that you "bone up" on the concept by consulting the following Excel Help Index topics...
1. Consolidate data
2. Guidelines for specifying source areas for a consolidation
3. About creating a PivotTable to consolidate multiple data ranges