Want to create a dynamic master sheet based on data from other worksheets

Hi All,

This is my first post, so bear with me.

I want to create a shared workbook with 5 different users updating 5 different sheets. Now I want each of those data tables to populate as a combined table in another sheet. These are not numbers, it is plain text, and so the 5 tables have to be stacked one under the other with common header.

My challenge is every month the data changes and the number of rows for each table might vary and the master table should update/ add or delete empty rows. Can someone help me with the formula or VB script for this.

Thanks
PG

.
This code will copy all sheets in the workbook to the MAIN SHEET. One sheet content below the other with an empty row separating the data.

Please Login or Register  to view this content.

The other part of your project involves copying the involved sheet from each employee, to the Main Workbook. Do a search for "Copy sheet to other workbook".
You will want code that creates a new sheet in the MAIN WORKBOOK for each sheet that is copied into it.

Thank You. Let me try that