title: Laravel Excel Import, Multiple Sheet Validation
body: <p>I have maatwebsite Excel package to import an Excel document. The Excel document has multiple sheets, So i have a import class which defines the other import classes to use for each sheet.</p>
  <p>All the importing and validation works fine, up to the point where i want to skip on errors and failures and collect them all at the end.</p>
  <p>As i understand it, an array for errors and failures are add to the import class through the traits, and these get populated as the import happens.</p>
  <p>Problem is, the arrays are on each sheet import class not the main import class that defines the sheets, so i cant access the arrays.</p>
  <p>php7.3,
  laravel8,
  maatwebsite/excel 3.1,</p>
  <pre><code>class MainImport implements WithMultipleSheets, WithProgressBar
  {
  
  use Importable
  
  
  /**
   * Define schema classes for each sheet in the excel document.
   * @return array
   */
  public function sheets(): array
  {
      return [
          'first sheet' =&gt; new FirstSheetImport(),
          'second sheet' =&gt; new SecondSheetImport()
      ];
  }
  
  
  }
  </code></pre>
  <p>Import class for sheets, second would be some thing similar but own validation rules, own model etc</p>
  <pre><code>class FirstSheetImport implements ToModel, WithHeadingRow, WithValidation, SkipsOnError, SkipsOnFailure
  {
  use SkipsFailures, SkipsErrors;
  
  
  public function rules(): array
  {
      return [
          'name' =&gt; 'required'
      ];
  }
  
  /**
   *
   * @param array $row
   * @return Model
   */
  public function model(array $row)
  {
  
      Model::updateOrCreate([
          'id' =&gt; $row['asset_id']
      ],[
          'address' =&gt; $row['address'],
          'name'  =&gt; $row['name'],
          'carrier_name' =&gt; $row['cp_name'],
      ]);
  }
  }
  </code></pre>
  <p>This is the basic idea behind the logic</p>
  <pre><code>$import = new MainImport();
  
  $import-&gt;import(file.xlsx); // so MainImport is actually using FirstSheetImport etc to import each sheet
  
  if ($import-&gt;errors()) {
      //do something with the errors from each sheet - but arrays not on MainImport
      // same with failures
      // dont seem to be able to reference the sheet import classes to get to the arrays either
  
  }
  </code></pre>
  <p>I cant see how i would capture the failures/errors from each sheet import on the MainImport.</p>
  <p>Any ideas how to solve this, or restructure the logic?</p>