Help pulling data from multiple workbooks

Hello, I'd be grateful if anyone could help. I'm working with a large data set, that will be split into 30-50 workbooks for different colleagues to work on different categories. It needs to be diff...