Array Formula or Solution to make Data Power BI Compatible

I have data as per Image 1 and I need it to return it as a list as per Image 2. So basically the excel file is a Construction equipment workbook with separate sheets for separate construciton equipment. How to do it. I want this data as a list such that it can be used in Power Bi. The data in its existing form is useless for the Power BI. The Data is similar in all the sheets but with different column nos. Can someone pls help me on this?

Now when I copy paste the same to chatgpt, it gives me the data in the required data in the required format, but the problem is data is continuously getting added to the sheet, so the chatgpt wont solve the problem