Macro to Copy headings from sheet BR to BR consolidated and copy data from BR1 to BR7

I have tried to write code to do the following


1) Copy headings from sheet "BR1" to BR Consolidated
2) Copy data from row 2 Cols A:I from shets BR1 to BR7 to BR Consolidated


However, the headings are not being copied into cels A1:I1 on sheet BR consolidated nor is the data copied correctly


It would be appreciated if someone could kindly amend my code

Please Login or Register  to view this content.

I have managed to rewrirte my code to copy headers fro sheet BR1 and the data from row 2 to last row containing data in Col I frrom sheets BR1 to sheet before BR Consolidated

Please Login or Register  to view this content.

However I get a run time error end with without with


Kindly test and amend my code