macro to take value from different workbook and get their respective column value

[jitendra6872]

here,
i attached a file where i want a macro in which instead of workbook i placed values in sheets.
what i want is when value circle values are found in different different workbooks when value change in the or add in the circle name column it will take values automatically from sheets/workbooks.

 

[Debraj]

Hi Jitendra!

Welcome to the forum..
Please spend some time http://chandoo.org/forum/forums/new-users-please-start-here.14/

and regarding your query..

* Do you want to create.. Sheet1 Sheet2.. from Sector data file.. or
* You want to create Sector Data sheet from all other sheets..

 

[jitendra6872]

i want to create sector data sheet from all other sheets or workbooks