consolidating multiple sheets onto one pivot table report (1 Viewer)

Hi

Is there an easy way to consolidate multiple sheets into one pivot table in excel when text is being used rather than numbers?

I want the behaviour to work in such a way such that when say sheet 2 has something in a cell that sheet 1 as already filled then sheet one should take priority over sheet 2's value.

can this be done easily?

thanks

Howdy. Here is a tutorial and example on how to do that: Contextures on Pivottables, using MS Query.

And from the Horse's mouth, er... Microsoft, without using MS Query.
________
Lukumi Forum