Daily Web Scraping for Google Sheets

have highlights in tyellow what i need done, need a button to add an extra tab and extra row with all relevant formulas. Need import of car value from kelly blue bok or alternatives using data on the spreadhseet.
https://docs.google.com/spreadsheets/d/1cAy2eXABAV3W0WDrh_HuObDnqeSulNSVkwNUgCTA0cg/edit?usp=sharing