Selecting Criteria From Poorly Formatted Table?

Basically I have been presented with a table (which can't change) and isn't well formatted shown at bottom of page.

Ideally I want to like extract and cross analyise some of the elements in the table to load into a database. Due to the formatting I cannot find a way of doing this which identifies and picks out the relevant bits.

For example; how would I gather a way of identifying what the districts is, what the road type is (i.e motorway), whether it's rural or urban, and the totals for a number cross referenced factors (i.e total road lengths for Dacorum) based on the existing formatting?

I have tried indexing, vlookups, index, pivot tables, index match match ...all to varying degrees of success. Whilst these function to a degree if the table orders were to be formatted differently in the future these methods cease to work and I would have to check this manually.

Therefore if you can alert me to any possible way of picking factors based on criteria and then returning the results.

Example table (it has a number of headings and in a variety of positions within the page)...

Motorway and Trunk Roads
Principal Roads (De-Trunked)
(Route Length)

[Code]......