Help to use Sheet name to read other workbooks

[vidaLL]

Hi Guys, I really need help with the code below.
Basically i have many other workbooks with names like 2110, 4685 , 3345 etc. All workbooks are identical, with the same structure.
I have other (matrix) that contain information about all the other workbooks consolidated.Also inside i have some worksheets with the same name (2110,4685,3345).
So basically, the code below is in the Matrix and in my mind i can use it to get information from all other workbooks (2110, 4685 , 3345 ) using the worksheet name of the Matrix.
My problem : Actually i have one code to read each workbook. What can i do on this code code to get all informations from the workbooks and fill the MATRIX ?
I know that i need to change this part (path = ActiveWorkbook.Path & "\2110.xlsm" ) but i have no idea how can i do it.

Please Login or Register  to view this content.

Thanks for your time and sorry about my bad english.

[Richard Buttrey]

Hi,

YOU'll need to hold the workbook names in a list somewhere then use a loop to process the list. So suppose the list is named say "MyWorkbooks" and contains numbers like 2110, 4685..etc then.

Please Login or Register  to view this content.