update macro

[crizzle]

can anyone help me with a macro.. im have a workbook with a 'summary' page, with a macro button that should (in theory) update the 'summary' sheet with all the data in the last column from rows 'A-I' in the other sheets...

each sheet's column 'a' has a locked header, to display the discription of the information that follows below but when i run the macro, it only updates column 'a' (the header) but thats not what i need it to do, it should update the summary sheet with the last information input on each sheet, not the header info. does that make sense?

[royUK]

Attach an example workbook