They will be selling cars and will have the sub pages Available, Sold and Coming Soon within their main Cars section of website.

Is it possible to set up CMS so that a car detail page is created once and then can appear listed in each particular sub page area if a drop down menu category is selected in the car detail page in the CMS?

In essence I want to add the car details once in CMS. When it is added I want to be able to select which category it is in and as such it is then displayed in that category area in the website. Then when for example the car has been sold I want to be able to change the category in the CMS car detail page to the sold category and the the page will be automatically moved to the Sold area on the actual website.

According to the description, I assume you want to be able to filter cars based on their status (sold/new etc.) when getting the records from the database. You can add a new field "status" to the cars section, make it a pulldown with the possible status you want. And on the front-end pages you can add a where statement to filter the records you get from getRecords like this:

I've noticed that it's not going to be suitable for the website as the sold and available sections have some different graphic markings in their html template. So I will simply recreate the car when it becomes sold.

I'm sure the advise will come in useful for future sites though so thanks.