Copy named sheets from one workbook to names sheet in other

Hi I need help to get a macro to copy named worksheet from one workbook to named worksheet to other workbook.

My source workbook name is 5 aug customervalidation.xls
my target workbook name is Check DD Setups.xls
I can open both workbooks before copy.
I need copy from following sheets from source workbook to target workbook.

AT to Austria
BE to Belgium
FR to france
IT to Italy
NL to Netherlands
PT to Portugal
ES to spain
IE to Ireland.

Would be great if it can copy from row 2 and all used rows. to row 2 in target sheet.

Some sheets have over 5000 rows so also need to consider the speed.

Please have a look I have searched and many topics for this, but now found some yet I think consider all I need.

Please have a look.

Sincerely

Abjac

I guess it don't need a test sheet for this

Hi Abjac,
try

Please Login or Register  to view this content.

Hi Nilem. Your code seems to be brilliant. There is only some I didn't notice first. Sorry for that. In workbook 5 aug customervalidation.xls it need to start copy from row 9. I didn't notice that. Can your code be made so this is possible to change? But your code is brilliant so fast also.
Please have a look at the last question.

Thanks in advance

Sincerely
Abjac

Thanks Nilem the last one is the one works perfect it tested I think the range A2 refer to the sheet where it copy to.

But it works brilliant. Thanks allot

Have a nice day

Sincerely
Abjac