Refer to multiple data sheets to return cell content

[josh.leslie]

I have 3 separate pivot tables (fed by 3 data sources) on 3 separate worksheets within a single workbook that are all linked to 1 slicer. Based on the slicer selection there can only be data populated in 1 of the pivot tables, the other 2 will be blank. I am trying to create a formula that will look at A2 on each of the 3 pivot tables and return the cell data for the one that is not blank. I have tried IF, AND, ISBLANK and cannot come up with the right combination to return the cell content. I can get it to work with 2 tables, but not the 3rd. Any ideas?

[#2]

Can you please post an example file with non-sensitive data It's often easier to address the issue with a sample file or a more concrete example of the data representation.  This will make it easier for other community members to answer your inquiry.

It's hard to tell without an example but you may try a combination of IF() and GETPIVOTDATA()