I need to have in the same cell; data from 3 differents reports. And be able
to "easily" swich wich report I want the data from on that cell.

ie: cell "A1" has the "Report 1" data, but now I want in the same cell (A1)
to have the report 2 data.

Report 1 and Report 2 have almost the same data but in different locations.
That's why I was trying to avoid creating a pivot table.

Of course the data in cell A1 means the same for both reports.

Thank you