Consolidate Identical Workbooks

[Cmacvp16]

I have 190 workbooks with an identical summary sheet that tracks the number of steps each employee logs on their walking journal.

How can I consolidate these 190 workbooks into a master file?

 

[stevebausch]

Sounds like a stock task, you may want to try searching the web (as well as this site). When you are done you should have various techniques to consider.

You also need to consider how the consolidation is to be 'driven', do you want the 190 users to click on a 'Send My Sheet' button, and do the copy and paste? Or, do you want to sit down and click a "Gather Sheets" button on your end? Or, do you want to open a workbook and have it automatically go out and gather the sheets?

Or.....do you want an Workbook_Open, or a BeforeClose macro to test for a particular time/date, and if True, send off the sheet?

What about timestamps? How about any =Today() cell functions? You will need to copy and Paste-Special to lock the dates if you want to freeze them.

How do the end-users want this to happen? Automatically? Is there a need to revise sheets?

The more you can flesh out the project, the more our members here can offer advice as to implementing your plan.

 

[Cmacvp16]

Thanks for the help. I want to gather the worksheets into a master file that I will import to Access for some basic reporting. Currently I am collecting the 190 workbooks and need the data from the summary worksheet in each workbook.

I apologize for my lack of experience in writing code or having advanced application development experience.