Copy cells from one sheet to another and convert to a row

[pachmarhi]

I am not sure where to start with this, so some guidance would be appreciated.

I have some data in a collection of old sheets that has been stored as kind of several 'mini tables' within each sheet. I want to extract the data into standardised rows so that it is easier to analyse, import into Access, etc.

It may be that I have to place the cursor in the starting cell for each mini-table and then run a macro, or there may be another way to automate this more, but if someone could point me in the right direction that would be a great help.

Attached is my sample sheet in Excel 2013 format. And below are two images.

The first, the existing data format. Cells in green in the first mini-table identify the cells for each table that need to be copied, though if other cells get copied, I can always delete the unwanted columns. There are about 80 of these in the sheet and I have several years worth of data to reformat.

The second image is an example the way I want to restructure the data in the new table. Apart from the first cell for each record, the rest are all integers.

Thanks in advance for any help you can offer.

Krishna