Hi Hernan,

Suppose the data you want to display is in Sheet2!A5, Sheet3!B10 and
Sheet4!M20

In cell A1 on sheet1 enter the following formula:

=CHOOSE(A2,Sheet2!A5,Sheet3!B10,Sheet4!M20)

In cell A2 enter 1, 2, or 3. The formula will return the data from the 1st,
2nd or 3rd range referenced in the choose function.

You can give them a drop down list in A2 using Data Validation.

There are many other ways to impliment this idea, for example your drop down
list could be a list of the sheet names and you could employ the INDIRECT
function within the choose function.
--
Cheers,
Shane Devenshire


"HERNAN" wrote:

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