Copying data by VBA using Current Region Property

I am trying to copy the data from all the years from 2006 to 2012 to all "task1" sheet. But the condition is that when new data is in any of the sheet after row 55 it should show in "task 1" sheet when I run the macro. I tried this code using current region property for sheet "year 2006". But when used the same code for" year 2007" and so on the macro also copies column A which I don't want onwards 2006 as the column A is same for all years.

Please Login or Register  to view this content.

I am trying to avoid loop.

Well, I've opened the file and ...
column A is not the same for all years
in 2006 INTEREST is in A8, while in 2007 in A11 and so on

By the way, why you try to use currentregion at all?

Please Login or Register  to view this content.

If the reason is because the content of column A is different some years, the the approach would be quite different (depending on the character of changes of colunm A content)

Instead of

Please Login or Register  to view this content.

Use

Please Login or Register  to view this content.

If you want to copy sheets from 2007 to 2013

Please Login or Register  to view this content.

Any cell selected within the region the currentregion will select the entire range. Since you have selected B11, I selected B10. The address is A7: last cell in region.

Since data is required from B11, Which is offset(4,1) from A7, offset is used. After the offset the range starts from B11.
Since only one column is required resize(,1) is used.
I hope I am clear.