Trying to combined data from separate sheets

[jeck876]

I have 3 months of data in 3 different sheets. I want to combine all the data into one sheet.I am looking for a way to use a function, macro, or add-in to make this process easier and less time consuming.

The data is split into 6 columns. Each month has these 6 columns but the amount of rows change from month to month.

The finished product should just be one sheet with the 6 columns and amount of rows equal to the sum of rows for each month.

I know this description is a little confusing, but thank you in advance.

[SHANBURR]

I dont know the answer but Following this thread as I'll be doing something similar soon. Good luck to you!

[newdoverman]

Here is a sample workbook that you should be able to follow to create a master worksheet out of the worksheets in your workbook.

[jeck876]

This site was very useful in solving this problem.

https://msdn.microsoft.com/en-us/lib...ffice.14).aspx