Power Query - Combine Excel files with different sheet names

A man has built a rechargeable battery pack big enough to power his whole home - using the batteries from discarded vapes. Electronics engineer Chris Doel, 26, stripped the lithium batteries from 500 binned vapes to create a single one large enough to run his entire house electrics for eight hours. He wired the 2.5 kWh battery in to his home with an inverter and ran all electrical components entirely off-grid for eight hours, including the microwave, kettle, and all lighting. Chris, who works fo