The file structure is as such (with different names);

Home
- Building 1
- 102 Charly
- Documents
- 104 Dave
- Documents
- 111 Fred
- Documents
- Building 2
- 221 Mary
- Documents
- 234 Sue
- Documents
- 258 Lisa
- Documents

The xls file is in the documents folder. The workbook has the same name
and
the worksheet is also the same name. It is on a network mapped drive.

A follow up question... are you looking to combine worksheets in all the
Building directories taken together, or in each Building directory
individually?

Rick