Macro Connect the same values in others worksheets in different files..

Hi Everybody!

T need your help, about a macro to connect the same values in other worksheets:
I have a Master Data, (name: ACO.xls) and others sub excel files (ACO-001-12.xls, ACO-002-12.xls, ACO-003-12.xls, etc) How do I put the values the same values in only ACO.xls but in multiple files automatically:

Example:

Please Login or Register  to view this content.

In this example, only show me information in to first archive (aco-001-12.xls), but ..
I attach the data.
Thanks a lot!

Hello Feroguz. Try it.

Please Login or Register  to view this content.

One condition - the master file (in attachment), and source files (ACO-001-11, ACO-002-11, etc.) should be in the same folder.

OMG!! Thks a lot nilem!
Your the boss

If in the future, I'm going to update more extra files, how values in this code I need to change?
For example more sub excel files (ACO-004-12.xls, ACO-005-12.xls, ACO-006-13.xls... --> ACO-200-012.xls)?

I try, but the macro indicates me debug in .Range..

Best Regards!
Feroguz

The macro does not work at all, or does not work with the new files?
Error can only be if there is no sheet named 'ACI' in a source file.
And change this line:

Please Login or Register  to view this content.

Dear Nilem, The problem it's with one file do I have.
I'so stupid jeje!

Thanks again, and if you have a donate account pls, notify me.

Best Regards!