Move data from multiple tables onto a list to archive and analyse

Hi,
No one likes change! So this spreadsheet has been built to display data....

I'm trying to make it user friendly to save the data into a list. Before it is reset.

There are 24 tables on the sheet, all similar setup - only include top 8 in s/sheet.

I would like to capture all the data as shown in "Past data" sheet - I didn't put it all there. Each time a table is reset the data would be written to the end of this sheet - should hold a few years data!

What I was hoping was to start a macro when in the yellow cell and it would transfer data.

I tried recording a macro but too messy, then tried VB code (from this site) but didn't quite work.

Any thoughts?

I thought I could alter this VBA given in this post:
http://www.excelforum.com/excel-prog...to-a-list.html
But I got too confused!

Thanks!