Extract data table from a specific web url

I need to extract a data from this link: www.autotrader.com

First, in excel I need to create a data for the following dropdowns in the landing page, so when i hit the button in excel to extract, it would automatically pull the numbers depending on the data I entered from the link www.autotrader.com, it would return a table.

Anyone familiar with this?


Thanks.

Did you try the external data wizard?

Capture.JPG