Combining multiple worksheets into another worksheet

Hi, I am trying to find an easy way to combine 22 worksheets that are in 1 workbook. Each worksheet represents a program and all have identical columns (A through M). Each worksheet has a different and unknown number of rows.

I have added a new worksheet at the end called "Combined Log" and want to use this combined/consolidated worksheet during meetings to quickly show all incidents that were logged for the programs at one time.

I am consider myself an intermediate user with Excel, but have never really understood how to use VBA Project so have been unable to successfully use some help items I have found on the internet to solve my problem.

I am currently working in Excel 2007 and any guidance would be appreciated.

If you want a VBA solution, please attach a sample excel book. To attach a sample, go to advance then attachment.

Look at this code and try it:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button