Excel Programming (need to look into excel file closely)

Job ID: 38139611

Budget: $30 – $250 USD

I have a lot of data in a spreadheet.
Have a look at attached spreadsheet.
I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers.
Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import