using two data sheets in Pivot table

Hi ,

i need to create a pivot table with the use of two data sheets, is thr any way to achieve this other than by using multiple consolidate range ?/

thanks in advance
rj