PivotTable Fields Range References

Dear Excel Experts,

I have a question concerning pivot tables added to the data model.

Somehow I managed that one (PivotTable fields) range refers to three different tables in three different worksheets of the same workbook. But I don’t know anymore how I came to this result.

All other attempts produced ranges that refer to only one table.

I have been looking for seven hours in the internet and in my Excel books. And didn’t find any answer.

Can you explain to me how I produce a range that refers to three different tables in three different worksheets?

Thanks for your effort.

Best wishes

Luc