Need to consolidate data from multiple workbook into one workbook

help_excel

New member
Joined
May 29, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
MS Office 365 Pro Plus
1. There are 26 workbooks with 13 sheets in it. All the workbooks has same tabs and same columns but different data.
2. I am trying to consolidate 8 out of 13 sheets into one master workbook for some data gathering purposes.
3. My expectation is to create one master workbook which contains all the 8 required sheets and each sheet should contain data for all the 26 workbooks. Also, these workbooks are password protected. For example: if there are 3 sheets in 10 workbook : Travel , rent and training. Now i want to get travel data for all the 10 workbooks in one sheet and same for rent and training.

Hope this make some sense.

Please let me know any additional details are required.

Thanks!
 
Last edited:
Back
Top