Attempting to link multiple workbooks

.
.
The following allows the user to select a folder of their choice containing the "other workbooks". The "other workbooks" must all have the same extension as ".xls" (this can be changed in the coding if you desire).
None of the sheets contained in the "other workbooks" can be protected status.

This code will copy sheets from the "other workbooks" and paste them into the Master Workbook.

Please Login or Register  to view this content.

Capture.PNG

I'm attaching (hopefully) a picture of what I require.

This is Sheet1 of the employee workbook. Every manager saves this workbook for each new employee. As time passes they fill out their performance in the white/blank cells.

What I need to do is gather that information for ALL the employees onto in a separate workbook, and break that workbook down by category.

My hopes (which are being dashed quickly) are that I could have a page for their attendance, for their scores, for their daily dials, etc. Capture 2.PNG

And then, each time a new workbook is created/saved under a new employee name, that info would populate accordingly, and eventually I'd just have a big long list of all employees.

Ok, so I'm making another attempt at this "copy all books" macro, however, since I am BRAND new to the macros, I'm not sure where/how/what to change in the macro in order to specify my folders, workbooks specifically.

Any chance on an explanation?

Well, that makes sense. My only problem now is that it's written for a 32bit version and I'm using 64, so it fails every time. I'm doing some digging to find a fix, but I am no code writer, so if anyone has ANY SUGGESTIONS? That would be great.

Thanks for the heads up on the folder placement.

https://support.office.com/en-us/art...1-E9FC8ADEEEB5

You could use your Master workbook with the nice sheets to create a PivotTable that creates data "Connections" which can be the employee workbooks. Since they are all laid out the same, once they are connections, the PT can be set to refresh when open, and used as a consolidated data table for your nice sheets that are easy to read or ready for reports. If you are creating the employee workbooks, you can add the workbook as a connection to your master workbook at that time. If you don't create the employee workbooks, you could view the folder where they are saved before you need to run your report, and add connections for the ones that are new since you last checked. That would be the one manual step in the process.

Once the workbooks are all connected, if they are changed by the employees, that new data will feed into your PivotTable.

It seems that the employee sheets were created for visual impact versus table-oriented. They are nice looking, but the layout makes for difficult reading for PivotTable purposes. I don't know how many employee workbooks there are, but you could create an additional sheet on each workbook that is laid out row-table style for easy export to PivotTable which cell formulas that reference the cells on the nice pages that employees enter info into.

When you make connections in the PivotTable setup process, you are asked to pick a workbook, and then a sheet in that workbook...that is a single "connection."