Collating data from multiple sheets

**darrylfunky** · 04-08-2014, 01:08 PM

Hi,

I recently got promoted to a position of data analyst because I know a little excel. Our workers here input all their worked reference numbers with their queue description in different excel sheets on a daily basis and they are linked to a single sheet. So its like each person (like a 100 employees) has to fill a workbook with 31 sheets everyday. It is really congested and I was wondering if any one of you all have a simpler format and if there is any macro which could help me summarize the data on a daily basis on a different sheet. I don't know if I am making sense here but looking forward for some help.

**JBeaucaire** · 04-08-2014, 07:32 PM

I'm not grasping your scenario yet, but I've published many base macros on my site for you to consider as a starting point for common data manipulation needs. For instance:

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.
--------------

'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets in one workbook into a "consolidation" sheet where the source sheets are the same layout.

Sheets to One Sheet - Part 1

There's a sample file there, too, to make it easy to try it out.
--------------