How and where in Laravel Excel to calculate cells from neighboring pages?

Question

Laravel

Is it possible to somehow implement formulas in Maatwebsite/Laravel-Excel in registerEvents that include cells from neighboring pages?
The bottom line is this, there are 3 pages:

1) DashboardWorksheet (there are only headings, and just here you need to file formulas)
2) EventWorksheet
3) I fill ProceedWorksheet

EventWorksheet and ProceedWorksheet from the database

And in DashboardWorksheet you need to drag data from EventWorksheet and ProceedWorksheet into certain cells with formulas .

There is a resulting file:

class SummaryExport implements WithMultipleSheets 
{
    public function sheets(): array
    {
        return [
            'TheBook Data' => new DashboardExport(),
            'TheBook Events' => new EventExport(),
            'TheBook Proceeds' => new ProceedExport(),
        ];
    }
}

Questions:
1) Is it possible to perform the calculation from neighboring pages?
2) Where is it necessary to perform the calculation - in SummaryExport or in DashboardExport ?

In which direction to dig?

Answer 1

Solved with php spreadsheets