can you pivot across several tabs?

i have a work sheet where the buyer plans a class 111 on tab 1, class 123 on
tab2....and my buyers are very good at pivots but we can't figure out how to
pivot across different worksheets.