Level 18
You can pass your 3 collections to your view and make 3 foreach in your view
return view('your-view', compact('solarInstalation ','inverterInstallations ','energyStorageInstallation '));
since your tables have some different columns I would recomend this way, so you can display your informations differently based on what items you are cycling through.
or
You can merge your collection before you pass it to your view.
$solarInstalation = Model1::all();
$inverterInstallations = Model2::all();
$energyStorageInstallation = Model3::all();
$mergedInstallations = $solarInstalation->merge($inverterInstallations->merge($energyStorageInstallation ));
return view('your-view', compact('mergedInstallations')]);