VBA Copy, Paste and Format

Okay I have been trying to set up this macro to copy and paste rows where a tick box is checked. The macro needs to transfer the row A:H over to sheet 2 then insent the data acording to property title either A, B, C etc. into formated tables which then feed into a bar and pie chart. I have tried posting this question up in sections hoping that i could get the bits of code i need and then work out how to do the macro but I have had no luck since my VBA skills are poor. I have attached the file I am working on and have provided an explaination of what i want to happen hopefully someone can work out what I want and provide me with a solution. Below are some sections of code that some very helpful people have provided me with they may assist you in helping me out or if you have a similar problem it may be useful.

NOTE: There may be up to 20 tables with 40 rows per table at times

Provided by Alan
VBA:

Please Login or Register  to view this content.

Provided by Tom
VBA:

Please Login or Register  to view this content.

URL TO SPREADSHEET

http://www.ozgrid.com/forum/attachme...7&d=1145420092

Is anyone having an attempt at this?

any ideas...anything?